You can apply the techniques in this web page to chart sheets:

http://peltiertech.com/Excel/ChartsH...ChartData.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
http://PeltierTech.com/Excel/Charts/
_______

ExcelMonkey < wrote:

Is it possible to export chartsheets and break their links. I have in
the past exported all the chartsheets from Workbook1 as Gifs and placed
them in Workbook2. The result is that all the charts get copied as
Gifs and then placed in Workbook2 in succession (i.e. vertically down
the 1 sheet).

The problem with copying them as Gifs is that you cannot click onto the
series after the fact. Furthermore, since they are all on the same
sheet, the user has to scroll down to view them. I want to copy the
chartsheet and then export it as chart sheet (not gif) into Workbook2.
Final result will be a new workbook with its own chartsheets with no
links.

Can this be done?


---
Message posted from http://www.ExcelForum.com/