Screen stay put during animate graph

[Brian F]

I have a table of values.
I have a graph (chart) graphically depicting those values.
I have a little vba program that cycles values into the equations that make up the data in the table and the chart becomes animated as the values change.

The problem: When I click the button to animate the chart the screen view changes to showing half of the data and half of the chart (or not, depending on I don't know what).

How can I either make the screen stay where it was before I activated the vba, or always display the same chosen portion of the spreadsheet ("C10:H55 for example) while the chart is animated?

 

[gardnertoo]

Show us your code, we can only guess without seeing what you did.

Here's my guess: If your code was the result of the macro recorder, you might have a .Select statement in there that forces the display to move to a different part of the worksheet.