Oct 17 2019 09:11 AM
Hello! Is there a way to produce graphics like this with Excel? :)
Nov 20 2019 12:18 PM
@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.
Jan 11 2020 10:24 AM
@Johnnie ThomasThanks 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 :)
Jan 11 2020 11:12 AM - edited Jan 11 2020 01:07 PM
@mattiapaoli I am not an expert in Power Point but I think It can be done, even, without VBA with Power Point if you play with slides and transitions.
I think that the thick is creating a slide by year, by month, by week...
Find out about Morph Transitions in Power Point.
I have tested it and can create same effect but with lot of work... every bar must be in a separate image...
Feb 16 2021 08:23 AM