Inspired by my collegaue – Manolo Alegré and his example in Excel to make a motion chart in Excel.
I made a new version of my Quadrant analysis model where the bubbles can move over time (or any other category)
This is something that will be possible out of the box in the next version of Excel … and also in the next version of SQL Server Reporting Services .. but while we wait this might be useful.
Here is a small video to demo it
Here is a link to the file –