Chart Text Box

  • Thread starter Thread starter Brian Lynn
  • Start date Start date
Jon, Steve and Andy,
One trick I almost always use, but untried in 2007, is to create the
chart natively in XL, copy the datasheet and the chart sheet to a new
file, Save that file in use the PPT code to insert object from file,
and then kill that XL file.

I haven't gotten deeply into 2007 since I don't have any clients that
have even considered upgrading. But that should work along with Jon's
insight into the OLE object concept.

Brian Reilly, MVP
 
Brian -

I believe this was one of the things I tried a year ago when trying to get a
handle on the Office-wide charting feature. And as far as I can recall, it
worked.

- Jon
 
Steve -

I haven't even begun to try to automate this, I suspect that's a blind
alley. 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
 
thanks for sending me this i will make sure your chart is there by tomorrow
what kind do you want i'll make sure ok love you kisses
 
Back
Top