Edit embedded chart from VBA

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

William N - 26 Oct 2006 18:34 GMT

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 ?

Reply to this Message

Steve Rindsberg - 27 Oct 2006 05:38 GMT

> 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

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

Reply to this Message