macro to update chart object

  • Thread starter Thread starter Ken Buonocore
  • Start date Start date
K

Ken Buonocore

I'm trying to write a macro to update the color scheme of
a chart, but the chart is a chart object formerly linked
to an Excel file. The datasheet will open, but when I try
to go through the steps necessary of selecting a data
series, changing the color, nothing gets written to the
macro. This is all that comes up:
ActiveWindow.Selection.SlideRange.Shapes("Object
129").Select
ActiveWindow.Selection.ShapeRange.OLEFormat.DoVerb
Index:=1
ActiveWindow.Selection.Unselect

Any help out there? Thanks
 
Ken,
When you are changing the properties of Graph you are working with another
application - MS Graph hence it does not record anything.
The quick way to deal with it is to use Excel to generate the macro code.
Perform the operation on an Excel chart within Excel itself and it will
generate the relevant code. With little editing that code can be copied into
PowerPoint and used.
 
Back
Top