Display a Chart Title
- Click anywhere on the chart you want to modify.
- Click Chart Tools Layout> Labels> Chart Title. 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. - Make a selection. A box with the words Chart Title appears on the chart.
- Double-click the Chart Title and drag across the words Chart Title. The words become highlighted.
- Type the desired title. The text you type replaces the words Chart Title.
- Click anywhere outside of the chart title to deselect it.
- Optionally, choose Chart Tools Layout> Labels> Chart Title, More Title Options. The Format Chart Title dialog box appears.
- Select Fill and then choose any desired background options for the chart title. Excel's Live Preview feature lets you view various options without first selecting them.
- Select Line, Line Style, and other title options, including color, shadows, 3-D formatting, and much more.
- Click ok.
You can't apply 3-D formatting or select a shadow if your title does not have a border line around it.
Customize the Chart Legend
- Click anywhere on the chart you want to modify.
- Click Chart Tools Layout> Labels> Legend.
- Select a placement for the legend or click None to turn off the chart legend.
- Click Chart Tools Layout> Labels> Legend> More Legend Options.
- The More Legend Options box offers the same type of formatting options as the Chart Title. Choose any desired options.
Click ok.
In this tutorial:
- Creating Charts in Excel 2007
- What is a Chart?
- Creating Basic Charts
- Formatting a Chart Element
- Insert Chart
- Chart Styles
- Adjust the Chart Location
- Display a Chart Title
- Displaying a Data Table in a Chart
- Change Axis Options
- Enhance a 3-D Chart
- Adjust Chart Data
- Creating and Using a Chart Template
- Working with Excel Charts
- Excel Charts Tips