I have a chart displaying a line graph.
I use a macro to change the data feeding the graph (in the same worksheet)
The macro erases the old data (ClearContents) and writes new data in the appropriate cells

When the graph is in view on the screen, then the chart does NOT update.
If I run the macro to change the data when the graph is off the screen (either by moving the chart or changing the zoom) then when I run the macro the graph DOES update!

What can be so quirlky that whether the graph updates or not depends on the maginfication ratio having the graph on the screen or not when I update it's data?

p.s. Calculation set to automatic.