Font Object

Contains the font attributes (font name, font size, color, and so on) for the specified object.

Using the Font Object

Use the Font property to return the Font object. The following example sets the title text for the value axis, sets the font to 10-point Bookman, and formats the word "millions" as italic.

With myChart.Axes(xlValue) 
 .HasTitle = True 
 With .AxisTitle 
 .Caption = "Revenue (millions)" 
 .Font.Name = "bookman" 
 .Font.Size = 10 
 .Characters(10, 8).Font.Italic = True
 End With 
End With