Excel changes the size of my chart by itself

[renatoab]

I'm having a trouble with chart size. In some of my charts, while running my macro, Excel changes automatically the size of my chart, turning it difficult to read (it is not an automatic way to make it more readable). While debugging it does not occur.
I found a way to avoid this while running: adding the code

Application.ScreenUpdating = True
Application.ScreenUpdating = False

Yes, one line just after the other, without anything between them.

The problem is: I don't want to show anything before the macro is done. Doing this way, the sheet is shown, with many unformatted things.

I'd like to know why this happens. Is there some setting to change this? If not (if it is a bug), has anyone seen the same problem, and knows a more elegant way to avoid it.

Thanks in advance

 

[Gerald Higgins]

I don't know if this will work, but perhaps try changing the "Object Positioning" attributes to "Don't move or size with cells" on the Format Chart Area dialog box.

 

[renatoab]

Maybe the Object Positioning solution could help.
I could not test it because after some modifications the problem didn't occur anymore (at least for a while).
The problem itself is not related with moving or resizing the rows and columns. The final result was different if the only difference was the presence of a break point.
If it occurs again, I'll try your suggestion.
For the ranges, there's the "dirty" attribute, that makes excel refresh the calculations.
I believe there's something similar for the charts and pictures (but something that we can't control) and in some cases it seems to fail.