Microsoft Office Tutorials and References
In Depth Information
Highlighting One Column
Instead of a title, this
chart uses a text box for
2. Select the plot area by clicking some whitespace inside the plot area. Eight resizing
handles now surround the plot area. Drag the top resizing handle down to make room
for the title.
3. On the Insert tab, click the Text Box icon.
4. Click and drag inside the chart area to create a text box.
5. Click inside the text box and type a title. Press the Enter key to begin a new line. If you
do not press the Enter key, Excel word-wraps and begins a new line when text reaches
the right end of the text box.
6. Select the characters in the text box that make up the main title and use either the mini
toolbar or the tools on the Home tab to make the title 18 point, bold, and Times New
7. Select the remaining text that makes up the subtitle in the text box and use the tools on
the Home tab to make the subtitle be 12 point, italics, Times New Roman.
Microsoft advertises that all text can easily be made into WordArt. However, when you use
the WordArt drop-downs in a title, you are not allowed to use the Transform commands
found under Text Effects on the Drawing Tools Format tab. When you use the WordArt
menus on a text box, however, all the Transform commands are available (see Figure 3.25).
A text box works perfectly because it is resizable and you can use WordArt Transform
commands. If you move or resize the chart, the text box moves with the chart and resizes
If your chart title is calling out information about a specific data point, you can highlight
that point to help focus the reader’s attention on it as shown in Figure 3.26. Although the
tools on the Design tab do not allow this, you can achieve the effect quickly by using the
To create the chart in Figure 3.26, follow these steps: