Chart Text Box

In article , Jon Peltier wrote:
Steve -

I haven't even begun to try to automate this, I suspect that's a blind
alley.

That's what I was thinking too. @*#$^*&^. And also @*^&**^!!!

But the manual process would be:

Select the chart
Edit Data (Chart Tools Design tab, or just right-click)
In Excel, do a save-as
Clean up this Excel file (remove any excess sheets, any excess data on the
data sheet)
Save and close the Excel file
Back in PowerPoint: Insert tab Object From File browse to file saved
above.

Now you've got an OLE-cognizant Excel chart.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______

"Steve Rindsberg" wrote in message
...
If you keep using the approaches that work in Office 2003 & earlier, that
is, you create the chart in Excel, then insert it into PowerPoint/Word as
an
Excel chart object, the result is an OLE object which VBA can manipulate.

That provides some relief, but still leaves us out in the cold when
presented
with already-created presentations (as I suspect Bengt is forced to work
with).

Can you think of any way of converting an existing chart object to a file
that
can be reinserted as you describe?

-----------------------------------------
Steve Rindsberg, PPT MVP
PPT FAQ: www.pptfaq.com
PPTools: www.pptools.com
================================================




-----------------------------------------
Steve Rindsberg, PPT MVP
PPT FAQ: www.pptfaq.com
PPTools: www.pptools.com
================================================