power point Help

[k_v_deepu]

Hi All,

I need some help in Powerpoint vba...
There are around 80 slides in the powerpoint and in each slide there is MSgraph object.
I need to change the Legend color in the graph.
Example: first legend is of Yellow color i need to change it to red
How can i do it using vba

Any help will be appreciated

Thanks in advance
Deepak

 

[nbrcrunch]

Powerpoint is not a discussion item on this board. I suggest you turn on the macro recorder and go through the step of changing the background and changing from one slide to the next. Then stop the recorder and examine the code that was generated. Chances are you will figure it out from there.

 

[mooseman]

Not sure why this isn't the place to discuss powerpoint here, as the title of this part of the board is questions concerning programs other than Excel or Access

This will give you an idea of where to start... I use it to change the stcked bars borders and the data lables attributes of an MSGraph chart in PPT.
I'm sure there are legend attributes that you can alter.

Hope this helps point you in the right direction.

Set oGraph = ActivePresentation.Slides(1).Shapes("Object 4").OLEFormat.Object
 
   With oGraph.ColumnGroups(1).Border = False
   End With

  
  For I = 1 To 3
    With oGraph.SeriesCollection(I)
     .HasDataLabels = True
   With .DataLabels
        .Font.Size = 15.75
        .NumberFormat = "0.0"   'change this as needed
        
     End With