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

C

chris

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!
 
C

chris

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 ?
 

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

Similar Threads

Countdown macro - display settings 2
How to Import Formatted text as new Slides in PowerPoint 0
.shapes().visible=True works in 2003 but not in 2007 6
Pasting Visio Image Into Power Point Issue 2
VBA 2007-customlayout 3
Formulas in Power point 3
Can not see Flash objects in Power Point 2007 1
Fonts get bigger when 'past special' excel 2007 chart to PowerPoin 0

Top