http://j-walk.com/ss/excel/tips/tip83.htm
A Class Module to Manipulate a Chart SERIES

from John Walkenbach's site.

--
Regards,
Tom Ogilvy

"Fernando" wrote in message
...
Hi,

Is there a way to read the SourceData from a Chart?, Ive read on the web
that cant be done.

There is a file that has this chart, then in a new WBook, it is copied the
chart and the sheet that contains the data for the chart. When I do this,
The
chart's SourceData points to the old WBook, so im trying to read the
SourceData so I can change it to be the same range but in the new WBook.

Can this be done programatically?, or is there a way to get rid of this
"link" with the old file?

Thanks !