Macro not showing animation!

I have a file with the data of movement of a group of people in a confined area. Now, depending on that I have built a macro and plotted it on the bubble chart.

However, the bubble chart jumps from the 1st to the last section. Please help me figure out when I press the button, I want that it should show the transition, so basically it becomes a moving bubble chart.

Hi Andy, thank you for your response. The data now shows the transition however can you also help me how the bubble chart will also move slowly to show each and every transition with the changing values. Is that possible.

I tried increasing the time in sleep function but it either becomes infinitely slow or else just jumps from first to last. What do you suggest?

Thank you so much again Andy.

I am looking for something like this in the you tube link : youtube.com/watch?v=pt6-Kp9LrbM

Go to 00:45 in the video and you will find the bubble chart moving. That's what I am looking for.

Thank you so much.