Edit embedded chart from VBA

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to edit the values of a chart that has been embedded into the
presentation.
I can select the Edit Chart from the menu when I select the object but when
I try to edit the values from VBA it says that it's a msoEmbedded object and
that it has no table to edit.

How can I edit that embedded chart from vba ?
Should (and how) I convert it to a chart ?
 
William N said:
I need to edit the values of a chart that has been embedded into the
presentation.
I can select the Edit Chart from the menu when I select the object but when
I try to edit the values from VBA it says that it's a msoEmbedded object and
that it has no table to edit.

Charts might be from MSGraph, Excel or some other program. You first have to
work out what program supplied them.

The shape's OLEFormat.ProgID property will give you that information.

If it's an MSGraph chart, there are some examples that may help here:

Working with MSGraph charts
http://www.pptfaq.com/index.html#name_Working_with_MSGraph_charts
 

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

Back
Top