Formatting Axis

R

Raimo Becker

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
 

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

Top