Formatting Axis

[Guest]

Hello everybody,

I want to use VBA to manipulate Axis Fonts/sizes/Types, because I have many
Slides to change. Can anybody give me a hint how to deal with this problem.
E.g. I select a Diagram an run a macro , but I don´t know which code I have
to use.
I Excel I use
Selection.TickLabels.AutoScaleFont = True
With Selection.TickLabels.Font
.Name = "Arial"
.FontStyle = "Standard"
.Size = 14
End With
ActiveChart.Axes(xlCategory)
TickLabels.AutoScaleFont = False
With Selection.TickLabels.Font
.Name = "Arial"
.FontStyle = "Standard"
.Size = 14
End with

Sorry but I can´t realize it in PPT

Thanks in advance
Raimo

 

[Steve Rindsberg]

Most of your code from Excel should work with MSGraph charts as well, once you
get a reference to the chart object.

Have a look here for some ideas:

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