Viewing data in a graph vary with 'real' time

[corus]

I have two columns of data which, via a command button and a macro to perform some calculations, the values change. When I plot these values I want the viewer to see the graph alter as the data changes. In the spreadsheet I see the data in the columns change but the graph just freezes, until the calculations have finished. So I see the initial graph and the final graph but no nice smooth change as the data varies. I've tried using a sleep function but that just seems to stop the macro from working, and the graph remains frozen until its finished. Any ideas on how to solve this?

 

[MintJulep]

Depends on what you macro is doing, but in general I'd think you need to force a sheet recalculation inside your macro.

 

[corus]

Many thanks. I've inserted ActiveSheet.Calculate within the macro and now it works fine.

 

[IRstuff]

I would agree with that assessment. Note also, doing so will probably slow down your macro by an order of magnitude. I don't think Excel can incrementally draw on a graph; it would refresh the entire graph each time.

TTFN
faq731-376