View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming,microsoft.public.powerpoint
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default Powerpoint and embedded Excel sheets

I'm not sure there's a less elaborate way to do this than move the data into
Excel, recreate the chart, remove the MS Graph object, and replace it with
the new Excel chart. And use an Excel 8 chart, because even though an Excel
12 chart supposedly interconnects better with Excel and PowerPoint, there is
no VBA access to an Excel 2007 chart in another Office 2007 application.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
_______


"Barb Reinhardt" wrote in message
...
I have a PowerPoint presentation that has the following embedded objects.

Excel.Chart.8
Excel.Sheet.12
Excel.Sheet.8
MSGraph.Chart.8

I'm cross-posting this to a PowerPoint group and an Excel group since I'm
thinking people in both groups may have dealt with this.

I'm thinking it would be easier for users who have to update this
presentation to only have to deal with one type of data entry. I've
found
that there is no way to programmatically convert the MSGraph.Chart.8
objects
to anything but MSGraph.Chart.8 objects. (Helpful, huh?). I see I can
manually convert Excel.Sheet.8 to Excel.Sheet.12. Is there some way to
do
this programmatically?

Thanks,
Barb Reinhardt