How to Add Titles to Excel 2007 Charts

By Diane Koers

You can add titles to a chart to help describe its purpose. By default, titles are not added when you create a basic chart, but you can add them later manually. In addition to a main chart title that is generally displayed above a chart, you can add descriptive titles to the x-axis (category axis) and the y-axis (value axis).

Follow these steps to insert and edit chart titles in Excel 2007:

  1. Click anywhere on the chart you want to modify.

  2. Click the Chart Title button in the Labels group of the Chart Tools Layout tab.

    A list of options appears:

    • None: The default choice; it means you don’t want to display a title. Also use this option to remove a chart title you don’t want.

    • Centered Overlay Title: Centers the title over the chart but retains the existing size of the chart.

    • Above Chart: Centers the title over the chart but adds room at the top so the title doesn’t interfere with the chart itself.

  3. Make a selection from the Chart Title drop-down list.

    A box with the words Chart Title appears on the chart.

    Adding a title to your chart.

    Adding a title to your chart.
  4. Double-click Chart Title and drag across the words Chart Title.

    The words become highlighted.

  5. Type the desired title.

    The text you type replaces the words Chart Title.

  6. Click anywhere outside the chart title to deselect it.

  7. (Optional) To add an axis title, click the Axis Titles button on the Chart Tools Layout tab and then select the axis and the type of title you want to add. Repeat Steps 4–6 to edit the axis title.