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

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.

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

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.
--
Thanks,
Christopher

This posting is provided "AS IS" with no warranties, and confers no rights.


"Rolex" wrote:

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.

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

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

"Christopher Scott [MSFT]" wrote:

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.
--
Thanks,
Christopher

This posting is provided "AS IS" with no warranties, and confers no rights.


"Rolex" wrote:

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.