Excel.Tips.Net ExcelTips (Menu Interface)

Selecting Fonts for a Chart

Please Note: This article is written for users of the following Microsoft Excel versions: 97, 2000, 2002, and 2003. If you are using a later version (Excel 2007 or later), this tip may not work for you. For a version of this tip written specifically for later versions of Excel, click here: Selecting Fonts for a Chart.

When creating a chart in Excel, you can add various elements to the charts, such as titles or data labels. Excel allows you to change the font used to display these elements, if you desire. You can change fonts for these elements individually. To do this, use these steps:

  1. Make sure your chart is visible on the screen and you have selected it. (You do this by clicking on the chart.)
  2. Select the text element whose font you wish to change. For instance, if you want to change the chart's title, click on the title. Excel displays small black squares around the element; this lets you know it is selected.
  3. Choose Selected from the Format menu. (The word "Selected" in the menu will be followed by the type of object you selected, as in "Selected Chart Title.") Excel displays the Format dialog box for the element.
  4. Make sure the Font tab is selected. (See Figure 1.)
  5. Figure 1. The Font tab of the Format Chart Title dialog box.

  6. Change the font settings, as desired.
  7. Click on OK.

ExcelTips is your source for cost-effective Microsoft Excel training. This tip (3399) applies to Microsoft Excel 97, 2000, 2002, and 2003. You can find a version of this tip for the ribbon interface of Excel (Excel 2007 and later) here: Selecting Fonts for a Chart.

Related Tips:

Excel Smarts for Beginners! Featuring the friendly and trusted For Dummies style, this popular guide shows beginners how to get up and running with Excel while also helping more experienced users get comfortable with the newest features. Check out Excel 2013 For Dummies today!


Leave your own comment:

  Notify me about new comments ONLY FOR THIS TIP
Notify me about new comments ANYWHERE ON THIS SITE
Hide my email address
*What is 5+3 (To prevent automated submissions and spam.)
           Commenting Terms

Comments for this tip:

There are currently no comments for this tip. (Be the first to leave your comment—just use the simple form above!)

Our Company

Sharon Parq Associates, Inc.

About Tips.Net

Contact Us


Advertise with Us

Our Privacy Policy

Our Sites


Beauty and Style




DriveTips (Google Drive)

ExcelTips (Excel 97–2003)

ExcelTips (Excel 2007–2016)



Home Improvement

Money and Finances


Pests and Bugs

Pets and Animals

WindowsTips (Microsoft Windows)

WordTips (Word 97–2003)

WordTips (Word 2007–2016)

Our Products

Helpful E-books

Newsletter Archives


Excel Products

Word Products

Our Authors

Author Index

Write for Tips.Net

Copyright © 2016 Sharon Parq Associates, Inc.