How to save an Excel 2007 Chart as a xml File.

[Rolex]

I have a Excel 2007 file. It has a data source and a chart on the same
worksheet. I would like to save this file as a xml file. The problem is not
saving the file as xml but once the xml file is created excel is only
creating a xml file with the data and NOT to chart. Can excel output a chart
as a xml file. Any help. Thanks.

 

[Christopher Scott [MSFT]]

If you save your workbook to .xlsx, rename the file to a .zip file extension,
open it up, go to the xl folder, you will see a chart1.xml file that
represents just the chart with cached values.

There is no such thing as "Save chart to XML" in Excel; it's a subpart of a
the workbook.

 

[Rolex]

Thanks alot, I will try is out and let you know. Thanks again.