'Is it possible to use the built in chart animations in excel when updating source data for charts?

When I change the source data in excel the pie chart I am using has a nice, fluid animation to represent the updated value(s). However, when I update the same value(s) via a VBA macro it doesn't animate at all and just snaps to the updated chart.

Is it possible to retain this fluid animation feature when updating chart data with VBA code?

The version of excel I'm using is Microsoft® Excel® for Microsoft 365 MSO (Version 2112 Build 16.0.14729.20312) 64-bit in case it's relevant.

Thanks.

excel vba

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution	Source

'Is it possible to use the built in chart animations in excel when updating source data for charts?

Sources

Related Questions