Chart Text Box

[Jon Peltier]

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

 

[Jon Peltier]

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

 

[Andy Pope]

Here is a version of the code to add textboxes to a bar chart.

http://www.andypope.info/vba/Axislabel_textboxes.htm

I do not auto size the textboxes, they fill the space between chart area
and plotarea.

Cheers
Andy

 

[cutie]

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