Excel 2007 For Dummies
Book image
Explore Book Buy On Amazon

In Excel, you can use the Add Chart Element→ Legend command on the Design tab to add or remove a legend to a pivot chart. When you click this command button, Excel displays a menu of commands with each command corresponding to a location in which the chart legend can be placed. A chart legend simply identifies the data series plotted in your chart.

You can also choose the More Legend Options command, which is the last command on the Legend menu, to display the Format Legend pane. The Format Legend pane allows you to select a location for the legend and also to specify how Excel should draw the legend.

The Format Legend pane.
The Format Legend pane.

In Excel 2007 or Excel 2010, you use the Legend command on the Layout tab to add or remove a legend to a pivot chart and to customize a legend. Note that in Excel 2007 or Excel 2010, the More Legend Options command displays a Format Legend dialog box rather than a Format Legend pane.

About This Article

This article is from the book:

About the book author:

Greg Harvey, PhD, was president of Mind Over Media and a highly skilled instructor. He wrote computer books for more than 20 years, and his long list of best sellers included all editions of Excel For Dummies, Excel All-in-One For Dummies, and Excel Workbook For Dummies. He died in 2020.

This article can be found in the category: