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

  • Thread starter Thread starter Rolex
  • Start date Start date
R

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.
 
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.
 
Back
Top