And the eye tends to focus on the big objects. It’s not easy to compare differences in size. The size dimension is a different from the X and Y axes, though. It lets you compare three dimensions at a glance. Or the growth, margin and market cap of companies. For example, the chart below could be the birth, literacy rate and population of countries (X-axis, Y-axis and size). Add a scroll bar and a play button linked to the “today” cellįor the impatient, here’s a motion chart spreadsheet that you can tailor to your needs.įor the patient and the puzzled, here’s a quick introduction to bubble and motion charts.Ī bubble chart is a way of capturing 3 dimensions. Make a bubble chart with that lookup table.Make a “today” cell, and create a lookup table for “today”.Get the data in a tabular format with the columns. Creating motion charts in Excel is a simple four-step process.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |