Chart source data invalidated when workbook refreshed

[louis]

Hi all,
We have a workbook with vba code which fetches data from
the backend and displays it. Now i have a chart defined
for some data in this workbook and then i refresh this
workbook.
The problem is the chart source data is invalidated for
the new workbook data.
Any solution for this ?
Any help is highly appreciated

 

[Jon Peltier]

Louis -

How does the macro refresh the data? Could you make use of a dynamic
chart instead, for example, one that charts the last N points in the
table? Here's some Dynamic Charting examples and links:

http://www.geocities.com/jonpeltier/Excel/Charts/Dynamics.html

- Jon