Accessing a chart's sub-shapes programmatically

[Uzi]

Hi,

A diagram shape has sub-shapes called diagram-nodes which can be
accessed through the
DiagramNodes property of the parent shape.
My question is how do I access the sub-shapes of a chart - the series,
categories and elements the chart is composed of - programmatically?
It must be possible since when you assign custom animation to the
chart, the chart can be animated by series, category or by elements
within the series or category

Uzi

 

[Shyam Pillai]

Uzi,
Yes, it is possible to manipulate the chart elements in PowerPoint. However
if you are getting started with it; it is a lot easier to record a macro
manipulating chart elements in Excel and then look at the code and then
adapt it to PowerPoint. MS Graph is the common charting component.

 

[Uzi]

Hi Shyam,

Where do I locate this compnent? I don't see it in the object browser,
not in the pwerpoint library and not in the excel library..
How do I know what manipulations I can perform on it i.e. what
functions are available with this component?

Uzi

 

[Shyam Pillai]

Set a reference to the Microsoft Graph Component.

 

[Steve Rindsberg]

Hi Shyam,

Where do I locate this compnent? I don't see it in the object browser,
not in the pwerpoint library and not in the excel library..
How do I know what manipulations I can perform on it i.e. what
functions are available with this component?

Note that the MSGraph object model doesn't give you access to the graph's
shapes in the same way you'd access shapes in PowerPoint. Instead, you work
with the data, the colors assigned to different data series and so on.

If you really need to work with the shapes that make up the chart, you have to
ungroup it (which converts it from a chart into a set of PPT shapes that you
can access just as you would any other PPT shapes ... but you can't then turn
it all back into a chart.)