Microsoft Office Tutorials and References
In Depth Information
Adding, editing, and removing a legend
Note
Additional options for customizing chart titles are available via the Format Chart Title
task pane. To display the task pane, choose More Options on the Chart Title submenu,
or click Add Chart Element on the ribbon, choose Chart Title, and then choose More
Title Options. We discuss these additional options in Chapter 21 in the following
sections: “Formatting lines and borders,” “Formatting areas,” and “Formatting text.”
Adding, editing, and removing a legend
The steps for adding, editing, and removing a legend are essentially the same as those for
working with a chart title. For details, see the previous discussion.
You can choose to position a legend at the top, left side, right side, or bottom of the chart
area. Like the chart title, the legend is a floating text object; you can drag it to any suitable
location within the chart area.
Excel uses either column headings or row headings within your chart’s data block as default
legend text. (If there are no such headings, it uses dummy text, such as “Series 1” and
“Series 2.”) You can change the legend text by editing the column or row headings. If by
chance you want something in the legend different from what you have on the worksheet,
select the chart, click the Design tab on the ribbon, and then click Select Data. Suppose,
for example, that your data block uses spelled-out month names, but using those names
makes for a bulky, two-line legend. The foregoing steps would take you to the Select Data
Source dialog box, shown next:
Search JabSto ::




Custom Search