Data visualization can often be enhanced by animating charts on a time based dimension. This can help to convey trends and relationships that change over time. Excel does not have any native method to create charting animations but we can replicate it by using some VBA code to iterate through different source data for charts that update the visualizations dynamically.
The solution can update multiple dashboard information within the same loop and wait for a specified pause interval to create a total overall visualization on how data evolves over time. We created an example of this that charts world population by age forecast out to 2100 with data source from the UN. The example file with VBA code and animation functionality can be downloaded from here.
Excel Business Forums Administrator
Posted by Excel Helper on
There are currently no replies to the "Animated Charts with VBA" topic of the Excel Help Forum for Charting and Performing Technical Analysis.