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
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