Adding, Editing, and Removing a Chart Title

If you choose a layout option that includes a title, Excel provides the title for you. If your chart doesn’t already have a title, you can add one by selecting any part of your chart, clicking the Layout tab under Chart Tools, and then clicking Chart Title in the Labels group. On the menu that appears, click either Centered Overlay Title or Above Chart. The former places the title within the plot area. The latter centers it above the plot area, reducing the size of the plot area to make room. If you need to adjust the position of the title, select it, and drag its bounding rectangle.

However you create the title, you might have to edit its default text. (Except when you plot a single data series with ...

Get Microsoft® Excel® 2010 Inside Out now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.