Animated chart code needs speeding up

[NannyNetty]

Hi

I am using the following code to animate a population pyramid chart. As there are 20 years of data this only takes 20 seconds to run through. However we now want to include an additional 50 years of forecast data. This results in the animation taking over a minute to run. is there a way I can speed this up?

Please Login or Register  to view this content.

[Pepe Le Mokko]

Administrative Note:

Hi

to add code tags, you can just select the code and click the #button. You probably added tags manually using a backslash instead of a slash in the closing tag.
I corrected this for you.

[Andy Pope]

you could use the Sleep API to have finer control over the time delay

[NannyNetty]

Thanks Andy

Unfortunately I'm a macro dabbler rather than an expert and have no idea what Sleep API means

[Andy Pope]

Fair enough, here is a simple approach using a loop.
You can adjust the speed by changing the value in M1.

Please Login or Register  to view this content.

The down side is the amount of delay is affected by the power of the pc.

[NannyNetty]

That's perfect

Thank you