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

Turning Off Document Protection

If you protect your document using the tools that Word provides, at some time you may need to turn off that protection. ...

Discover More

Quickly Dumping Array Contents

Variable arrays are used quite often in macros. If you use an array once in your macro and then need to reuse it for ...

Discover More

Colors in an IF Function

You can use the IF worksheet function to test for a number of different conditions or values. You can't use it to check for ...

Discover More

Save Time and Supercharge Excel! Automate virtually any routine task and save yourself hours, days, maybe even weeks. Then, learn how to make Excel do things you thought were simply impossible! Mastering advanced Excel macros has never been easier. Check out Excel 2010 VBA and Macros today!

More ExcelTips (ribbon)

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

Changing Chart Type

Charts can either be embedded in a worksheet or take up an entire sheet by themselves. Changing from one type of chart to the ...

Discover More

Preparing a Chart Sheet for Printing

One type of chart that Excel allows you to create is one that occupies an entire worksheet. When it comes time to print such ...

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. 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 + 5?

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.