Change the font of Category Axis

  • Thread starter Thread starter Chirag
  • Start date Start date
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
 
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/
_______
 
Back
Top