update a single chart multiple times as a macro runs

[glad_ir]

Hello,

Hoping somebody can help me please.

Is there a command I can include in a macro that will update a chart?

I have a macro that adds data into a worksheet and the added data is used in a Chart (Chart name is Chart 17). The macro adds 1 data point at a time, pauses for 1 second then adds the next data point and so on. Currently my chart only updates once the macro finishes. Is there a way to force the chart to update after each data point is added?

Any help is much appreciated.

Thank you,
Iain

 

[StephenCrump]

Inside your timer loop:

DoEvents

will allow Excel to update the chart.

 

[glad_ir]

Inside your timer loop:

DoEvents

will allow Excel to update the chart.

Hi Stephen,

Thank you very much for replying. I have added "DoEvents" into the code as 3 places but it does seem to make a difference. The code runs as before and the chart doesn't update until the end of the code. Do I need to add anything else?

thanks, Iain

 

[StephenCrump]

Here's a simple example of what I had in mind, which works for me in Excel 2010: Draw graph

Sub DrawGraph()

    Dim t As Double
    Dim i As Long
  
    For i = 2 To 12
        Range("A2:A" & i).Name = "x"
        Range("B2:B" & i).Name = "y"
        t = Timer + 1
        Do While Timer < t
            DoEvents
        Loop
    Next i

End Sub

How are you adding data points? Coding your 1 second pauses?