Please Note: This article is written for users of the following Microsoft Excel versions: 2007, 2010, 2013, and 2016. If you are using an earlier version (Excel 2003 or earlier), this tip may not work for you. For a version of this tip written specifically for earlier versions of Excel, click here: Using Chart Titles.

Using Chart Titles

by Allen Wyatt
(last updated April 15, 2017)

3

Pretty graphics in a chart may look nice at first, but graphics alone seldom convey the entire message desired. Without titles, many charts would be cryptic at best and useless at worst. Titles add purpose and meaning to your chart. Excel allows you to add several different types of titles.

You should note that the titles available for any given chart will vary, depending on the type of chart you are using. For instance, the only type of title available with a pie chart is the chart title itself. Since there are no X, Y, and Z axes on a pie chart, there are no titles available for them.

To insert titles, follow these steps:

  1. Activate the chart by clicking on it, if necessary.
  2. Display the Layout tab of the ribbon.
  3. In Labels group, click the Chart Title tool. You'll see options that indicate where the chart title can appear; you should pick one. The title appears in your chart.
  4. In the Labels group, click the Axis Titles tool if it is available. You'll see options that indicate the axis titles you can display. Choose the options appropriate for your needs. The selected axis titles appear in your chart.
  5. Within the chart itself, click within a title box and modify the title text as desired.

To change the text contained within a title, you can always follow these same steps again. There is an easier, more direct way to change title text, however. All you need to do is click on the title. The title is selected and surrounded with a box and handles. When you move the mouse pointer inside the box, it changes to an insertion point. Click the mouse pointer once to edit the text.

Notice that if you press Enter, the cursor only moves to the next line; you are still adding to the title. To signify that you are finished entering title text, you must use the mouse pointer to select some other part of your chart or worksheet.

When you add titles to your chart, Excel places them in a position it feels is best for the title. Thus, an axis title will be centered on the axis. You can move titles very easily, however. To do this, use the mouse to select the title text. When you do, it becomes surrounded with a box and handles. Use the mouse to point to the border around the title. Press and hold down the mouse button. As you move the mouse, the title is also moved. When you release the mouse button, the title remains at the new location.

ExcelTips is your source for cost-effective Microsoft Excel training. This tip (6609) applies to Microsoft Excel 2007, 2010, 2013, and 2016. You can find a version of this tip for the older menu interface of Excel here: Using Chart Titles.

Author Bio

Allen Wyatt

With more than 50 non-fiction books and numerous magazine articles to his credit, Allen Wyatt is an internationally recognized author. He  is president of Sharon Parq Associates, a computer and publishing services company. ...

MORE FROM ALLEN

Controlling the Program Used with Hyperlinked Images

How to tell Windows which program to use for graphics with hyperlinks.

Discover More

Changing an Axis Title

Axis titles help a reader to understand what is being displayed in a chart. Adding descriptive titles can, therefore, make ...

Discover More

Creating a Form

Google Forms is a powerful tool you can use to gather feedback from others. Here are the steps you can follow to set up and ...

Discover More

Solve Real Business Problems Master business modeling and analysis techniques with Excel and transform data into bottom-line results. This hands-on, scenario-focused guide shows you how to use the latest Excel tools to integrate data from multiple tables. Check out Microsoft Excel 2013 Data Analysis and Business Modeling today!

More ExcelTips (ribbon)

Negatives in Pie Charts

Pie charts are a great way to graphically display some types of data. Displaying negative values is not so great in pie ...

Discover More

Using Go To to Jump to a Chart Sheet

Create a chart on its own worksheet, and you can display it by simply clicking the tab at the bottom of the Excel work area. ...

Discover More

Modifying Axis Scale Labels

You want your chart to display information as clearly and succinctly as possible. Modifying the labels used to indicate the ...

Discover More
Subscribe

FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."

View most recent newsletter.

Comments

If you would like to add an image to your comment (not an avatar, but an image to help in making the point of your comment), include the characters [{fig}] in your comment text. You’ll be prompted to upload your image when you submit the comment. Maximum image size is 6Mpixels. Images larger than 600px wide or 1000px tall will be reduced. Up to three images may be included in a comment. All images are subject to review. Commenting privileges may be curtailed if inappropriate images are posted.

What is 7 - 0?

2017-04-19 04:43:45

David Robinson

Worth adding that if you want a chart title to be dynamic (i.e. based on a formula), you can't do this directly, but you can enter the formula into a helper cell in the sheet, and then reference the title to this cell. To do this, click on the chart title, then click in the formula bar, type = and then click on the helper cell and press Enter.


2017-04-18 05:02:32

Peter Burke

Probably worth mentioning that the title of a chart can be variable.. e.g. instead of typing text in the column title enter "=a2" in the formula bar.

The chart title will be whatever is in A2... which in itself is just a normal cell to enter formulas etc.. So the chart title can be as sophisticated as you want it to be


2017-04-15 15:51:18

Gary

It would be helpful to see the macro instructions to set up chart titles and axis titles.


This Site

Got a version of Excel that uses the ribbon interface (Excel 2007 or later)? This site is for you! If you use an earlier version of Excel, visit our ExcelTips site focusing on the menu interface.

Newest Tips
Subscribe

FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."

(Your e-mail address is not shared with anyone, ever.)

View the most recent newsletter.