Chart position affects sub-routine speed

[EssKayKay]

I have an Excel 2007 spreadsheet where I track investment accounts. I have a sub-routine that updates a chronological list of values which is used to graph the progress. For the most part it works fine.

My question:
The routine runs quite quickly – around one second. However, if I reposition graph location by moving it up on the worksheet, the routine slows down. Sometimes it takes 4-5 seconds to complete (no biggie) but I’ve seen it slowdown to over 30 seconds. If I move the graph back to the original position it returns to a one second process. If I move the chart down, left, or right (just not up) the speed is not affected. Any suggestions would be appreciated?

Thanks,
Steve

 

[mole999]

application.screenupdating = false I can only imagine that something is being redrawn and the usual position has nothing behind it

 

[EssKayKay]

application.screenupdating = false I can only imagine that something is being redrawn and the usual position has nothing behind it

That did it - thank very much

 

[EssKayKay]

That did it - thank you very much

 

[mole999]

set it to True once it completes otherwise you might get a stuck screen

 

[EssKayKay]

Yup, I actually did that. Again, thank you for your time and consideration Mole999 - much appreciated. . . .