Chart source data invalidated when workbook refreshed

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

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...s/Dynamics.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
http://www.geocities.com/jonpeltier/Excel/index.html
_______

louis wrote:

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