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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Rolex - 27 Aug 2008 23:18 GMT

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.

Reply to this Message

Christopher Scott [MSFT] - 30 Aug 2008 10:05 GMT

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.

Signature

Thanks,
Christopher

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

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

Reply to this Message

Rolex - 30 Aug 2008 18:31 GMT

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

> 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
[quoted text clipped - 8 lines]
> > creating a xml file with the data and NOT to chart. Can excel output a chart
> > as a xml file. Any help. Thanks.

Reply to this Message