VBA to manipulate embedded textbox in PPT graph

T

T-Casey

Thanks in advance
Office professional 2003

I suupport an application which uses Excel and Powerpoint. The data from
Excel is moved into embedded MSGraph charts & embedded Excel tables in
Powerpoint.

I have a new slide from my business user that has 4 pie charts into which
she has added a number of text boxes to extend the data labels displayed in
the chart.

Example:
All Other
15.3%
(-2.3%)

I am having trouble writing VBA code that I can use to update the texbox
value.
The "All Other 15.3%" is the data label. and the "(-2.3%)" is the added
textbox.


Sincerely,
 
A

Andy Pope

Hi,

Embedded shapes within MSGraph are not exposed via the object model.

You could use additional data points with zero value and then use their
data labels to hold the extra information.


Cheers
Andy
 
T

T-Casey

Thank you Andy!

I suspected that this was the case because I could not find a reference in
the object browser.

I handled the solution by using custom text in the label itself which
included everything I needed. This turned out to be an easy task in VBA. And
removed the text boxes.

Again, thanks for your time and the information.

Sincerely,
Tom Casey
Project Supervisor
sanofi-aventis
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top