Forum Discussion
Hello! Is there a way to produce graphics like this with Excel?
mattiapaoli thanks for you interest in Excel charting.
We sometimes refer to this concept you are showing as a "Play Axis" which allow you to show multiple dimensions of your data changing over time. At the moment there is no default built-in way to give charts a Play Axis.
It is possible to spoof some this concept using formulas to pull a particular subset of data (say 1 particular year from a table of years) and VBA to cycle through which specific subset of data is pulled. This doesn't give as clean a view of some of the movement, but gets near the idea. We'd love to hear from users if supporting a play axis is desirable.
JohnnieThomasThanks Johnnie for the answer! That's very cool. A "smooth" movement in the chart would be lovely, but I understand that's not the main purpose of Excel 🙂