Excel: Maps and Animated Scatter Charts

This page is an advertiser-supported excerpt of the book, Power Excel 2010-2013 from MrExcel - 567 Excel Mysteries Solved. If you like this topic, please consider buying the entire e-book.


A scatter chart can show many dimensions. You have the typical X and Y axis. The size of the bubble and color of the bubble add two more dimensions. Finally, drag a date field to the Play Axis.

When you click the Play button, the points on the map will animate over time.

  1. Animated Scatter Chart with Time scrubber.

  2. Maps

For more resources for Microsoft Excel