Microsoft Office Tutorials and References
In Depth Information
Using a Long, Meaningful Title to Explain Your Point
Follow these steps to remove the legend, add data labels, and add a meaningful title:
1. From the Layout tab, select Legend, None, and then select Data Labels, Outside End.
2. Click the title in the chart. Click again to put the title in Edit mode.
3. Backspace to remove the current title. Type Market share has improved , press Enter,
and type 13 points since 2007 .
4. To format text while in Edit mode, you would have to select all the characters with
the mouse. Instead, click the dotted border around the title. When the border
becomes solid, you can use the formatting icons on the Home tab to format the title.
Alternatively, right-click the title box and use the Mini toolbar to format the title.
5. On the Home tab, select the icon for Align Text Left, and then click the Decrease Font
Size button until the title looks right.
6. Click the border of the chart title and drag it so the title is in the upper-left corner of
The result, shown in Figure 3.22, provides a message to assist the reader of the chart.
Resizing a Chart Title
The first click on a title selects the title object. A solid bounding box appears around the
title. At this point, you can use most of the formatting commands on the Home tab to
format the title. Click the Increase/Decrease Font Size buttons to change the font of all of
the characters. Excel automatically resizes the bounding box around the title. If you do not
explicitly have carriage returns in the title where you want the lines to be broken, you are
likely to experience frustration at this point.
Use the title to tell the
reader the point of the
When you have the solid bounding box around the title, carefully right-click the bounding
box and select Edit Text. Alternatively, you can left-click a second time inside the bounding