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