View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Christopher Scott [MSFT] Christopher Scott [MSFT] is offline
external usenet poster
 
Posts: 27
Default 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.