how to get chart to update during the code, with no pause & flicker after the code.

I have a code that edits a chart,
the code uses application.screenupdating=false that speeds things up and hides the changes happening.
I also have in the code a shape rectangle that comes up and says "please wait"
and then at the end of the code the message shape dissapears.

The code ends, and then the chart STILL visually pauses and flickers and updates, casuign a delay of about 1 second before fully changing.

Quesion: how do I get the chart to update completely during the code, and not after, to prevent the flicker and change after teh code. Is there a refresh function or something that would work?

thank you!

Here is the simplified code, that is changing the legend only in this case. The issue still persists, in that the graph visually updates after the "please wait" box (rectangle 1) dissapears (with a 1 second delay). I want enverything to update so that when the "please wait" message is hidden, the graph is complete.

any help would be appreciated, thank you.

Please Login or Register  to view this content.

Without the rectangle, the graph still visibly updates after the code is finished. Any ideas?