Get new chart's object properties created in Power Point 2007

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

Guest

How can I get the new chart object created in Power Point 2007 and make
changes to it ?

Chart can be added with the

ActivePresentation.Slides(1).Shapes.AddChart (xl3DPie)

But I cannot access it's properties with the code below. How can I do it ?

ActivePresentation.Slides(1).Shapes(1).Chart.ChartType

Thanks a lot in advance!
 
How can I get the new chart object created in Power Point 2007 and make
changes to it ?

Chart can be added with the

ActivePresentation.Slides(1).Shapes.AddChart (xl3DPie)

But I cannot access it's properties with the code below. How can I do it ?

ActivePresentation.Slides(1).Shapes(1).Chart.ChartType
Click to expand...

Have a look here:

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

You need to automate MSGraph, the application which creates the charts.
 
Thanks Steve for your message!

I am able to create an MS Graph (OLE) & an Excel Chart (OLE) in PP 2007 and
get their properties. The problem is that PP 2007 introduced a new chart
object (Excel 2007) and I have problem retrieving it's properties.

The command below creates the new excel chart created in 2007.

ActivePresentation.Slides(1).Shapes.AddChart (xl3DPie)

For a table object I can use

ActivePresentation.Slides(1).Shapes.Addtable (....)
ActivePresentation.Slides(1).Shapes(1).Table ....

but it does not work the same for chart also. Could it be that new charts
CANNOT be handled in VBA ?
 
For a table object I can use
ActivePresentation.Slides(1).Shapes.Addtable (....)
ActivePresentation.Slides(1).Shapes(1).Table ....

but it does not work the same for chart also. Could it be that new charts
CANNOT be handled in VBA ?
Click to expand...

That's exactly the problem. Sorry ... I didn't know you were using 2007.
 
Back
Top