Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to change the font size of a datatable of a chart in Excel 2003?

Status
Not open for further replies.

feipezi

IS-IT--Management
Aug 10, 2006
316
US
Hi,

It might be a simple question. I spent quite some time but the font size just won't change using code like the following; for 2007, I won't have this kind of problems.

Thanks in advance.


Sub FixFont()
With ActiveSheet.ChartObjects(1).Chart.DataTable.Font
.Name = "calibri narrow"
.FontStyle = "Regular"
.Size = 7
End With
ActiveChart.Axes(xlValue).Select
Selection.TickLabels.AutoScaleFont = True
With Selection.TickLabels.Font
.Name = "calibri narrow"
.FontStyle = "Regular"
.Size = 7
End With
End Sub
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top