Change the font of Category Axis

C

Chirag

I want to change the font Size of the category Axis.

I require the VBA Code to do that as the default font is too large and so
not every thing can be seen

Thanks in advance

Chirag
 
J

Jon Peltier

Easiest way to get the VBA syntax for something is to turn on the
recorder while you do that task. Depending what you meant by category
axis, you want one of these:

ActiveChart.Axes(xlCategory).AxisTitle.Font.Size = 8
ActiveChart.Axes(xlCategory).TickLabels.Font.Size = 8

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 
Top