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