Microsoft Office Tutorials and References
In Depth Information
Deleting a legend entry
Excel displays default series name ( Series 1, Series 2 , and so on) in the legend. To
add series names, choose the Chart
Source Data command and then select the
Series tab in the Source Data dialog box. Select a series from the Series list box,
activate the Name box, and either specify a cell reference that contains the label or
directly enter the series name. Alternatively, you can edit the SERIES formula, as
described in Chapter 3.
Deleting a legend entry
For some charts, you may prefer that one or more of the data series not appear in
the legend. To delete a legend entry, just select it and press Del. The legend entry
will be deleted but the data series will remain intact.
If you press Del when a legend key is selected, the entire series will be
deleted. The legend key is the graphic part of the legend entry.
If you’ve deleted one or more legend entries, you can restore the legend to its
original state by deleting the entire legend and then adding it back. You can use the
Show Legend check box in the Legend tab of the Chart Options dialog box to
perform these actions.
Working with Chart Axes
As you know, charts vary in the number of axes that they use. Pie and doughnut
charts have no axes. All 2-D charts have at least two axes, and they can have three
(if you use a secondary-value or category axis) or four (if you use a secondary-cat-
egory axis and a secondary-value axis). 3-D charts have three axes — the “depth”
axis is known as the series axis.
Refer to Chapter 8 for a variety of chart examples that use additional axes.
Excel provides you with a great deal of control over the look of chart axes. To
modify any aspect of an axis, access its Format Axis dialog box, which has five tabs:
Patterns: Allows changes to the axis line width, tick marks, and
placement of tick mark labels.
Search JabSto ::

Custom Search