Microsoft Office Tutorials and References
In Depth Information
Working with a Chart’s Legend
3. Click and drag within the chart to create the text box.
4. Start typing the text.
You can click and drag the text box to change its size or location. And when the text box is selected,
you can access the formatting tools using the controls on the Drawing Tools➜Format tab.
The accompanying figure shows a chart with a text box that contains quite a bit of formatted text.
The chart’s plot area was reduced in size to accommodate the text box.
There’s nothing special about a text box. A text box is actually a rectangular shape object that
contains text. You can change it to a different shape, if you like. Select the text box and choose
Drawing Tools➜ Format➜ Insert Shapes➜ Edit Shape ➜Change Shape, and select a shape from the
list. The Format Shape dialog box gives you lots of options for changing the look of the text box.
If you would like to link the text box to a cell, follow these steps:
1. Select the text box.
2. Click the Formula bar.
3. Type an equal sign (=).
4. Click the cell that will be linked to the chart element.
After you create the link, the text box will always display the contents of the cell it’s linked to.
Some people prefer to use a text box in place of a chart’s title because a text box provides much
more control over formatting. When a text box is selected, its Format Shape dialog box provides
several additional options, compared to the Format Chart Title dialog box.
Working with a Chart’s Legend
A chart legend identifies the series in the chart and consists of text and keys. A key is a small graphic
image that corresponds to the appearance of the corresponding chart series. The text displayed in a
legend corresponds to the series names. The order of the items within a legend varies, depending on
the chart type.
Search JabSto ::

Custom Search