Extracting Embedded Charts from PowerPoint 2003

[Guest]

I have a large number of charts that are embedded into PowerPoint which would
be much easier to work with if they were extracted and placed into Excel.
The advice on this is always the same, to right click the chart, choose Chart
Object > Open and then do a Save As Excel Workbook. Unfortunately, this
doesn't work.

When I choose the Chart Object > Open, the chart opens in Microsoft Graph,
not in MS Excel, and there is no Save As option in the menus. I have also
tried reducing the chart to an icon, then drag/drop it to my desktop to see
if I could then open the resulting file with Excel. All this does is create
a scrap file, which Excel doesn't recognize.

Is there some other way to save embedded charts, other than what I described
above? The charts are all custom, and will take days to re-create in Excel
if I have to do them by hand. Thanks!

 

[Echo S]

The advice to right-click and save as Excel workbook is for Excel charts
embedded in PowerPoint. You have a typical PPT chart and want to get it to
Excel, which is a different situation.

I don't know of a way to get the PPT chart into Excel, though, without just
copying the data, pasting it into Excel, and recreating the chart. I'd
imagine you could do it with code, but I don't know for sure. Hopefully
someone who does will stop in soon.

 

[Steve Rindsberg]

I have a large number of charts that are embedded into PowerPoint which would
be much easier to work with if they were extracted and placed into Excel.
The advice on this is always the same, to right click the chart, choose Chart
Object > Open and then do a Save As Excel Workbook. Unfortunately, this
doesn't work.

When I choose the Chart Object > Open, the chart opens in Microsoft Graph,
not in MS Excel, and there is no Save As option in the menus. I have also
tried reducing the chart to an icon, then drag/drop it to my desktop to see
if I could then open the resulting file with Excel. All this does is create
a scrap file, which Excel doesn't recognize.

Is there some other way to save embedded charts, other than what I described
above? The charts are all custom, and will take days to re-create in Excel
if I have to do them by hand. Thanks!

It may be simpler in the long run to leave the charts in MSGraph, since that's
what created them. I've never heard of a way to convert between MSGraph and
Excel.

 

[Steve Rindsberg]

I don't know of a way to get the PPT chart into Excel, though, without just
copying the data, pasting it into Excel, and recreating the chart. I'd
imagine you could do it with code, but I don't know for sure. Hopefully
someone who does will stop in soon.

You can do quite a bit of it in code but it's not a trivial project.