Modify chart legend entries

When a chart has a legend (legend: A box that identifies the patterns or colors that are assigned to the data series or categories in a chart.) displayed, you can modify the individual legend entries by editing the corresponding data on the worksheet (worksheet: The primary document that you use in Excel to store and work with data. Also called a spreadsheet. A worksheet consists of cells that are organized into columns and rows; a worksheet is always stored in a workbook.). For additional editing options, or to modify legend entries without affecting the worksheet data, you can make changes to the legend entries in the Select Data Source dialog box.

What do you want to do?


Edit legend entries on the worksheet

  1. On the worksheet, click the cell that contains the name of the data series (data series: Related data points that are plotted in a chart. Each data series in a chart has a unique color or pattern and is represented in the chart legend. You can plot one or more data series in a chart. Pie charts have only one data series.) that appears as an entry in the chart legend.
  2. Type the new name, and then press ENTER.

The new name automatically appears in the legend on the chart.

Top of Page Top of Page

Edit legend entries in the Select Data Source dialog box

  1. Click the chart that displays the legend entries that you want to edit.

This displays the Chart Tools, adding the Design, Layout, and Format tabs.

  1. On the Design tab, in the Data group, click Select Data.

Excel Ribbon Image

  1. In the Select Data Source dialog box, in the Legend Entries (Series) box, select the legend entry that you want to change.
  2. Click Edit.

 Tip   To add a new legend entry, click Add, or to remove a legend entry, click Remove.

  1. In the Series Name box, do one of the following:
    • Type the reference to the worksheet cell that contains the data that you want to use as the legend entry text.

 Tip   You can also click the Collapse Dialog button Button image  at the right end of the Series name box, and then select the worksheet cell that contains the data that you want to use as the legend entry. When you finish, click the Collapse Dialog button again to display the entire dialog box.

  • Type the legend entry name that you want to use.

 Note   When you type a new name, the legend entry text is no longer linked to data in a worksheet cell.

  • To add a new legend entry, type the reference to the worksheet cell or type a new name and then, in the Series values box, type a reference to the data series on the worksheet that you want to use for the new legend entry.

 Tip   You can also click the Collapse Dialog button Button image  at the right end of the Series values box, and then select the data series that you want to use for the new legend entry. When you finish, click the Collapse Dialog button again to display the entire dialog box.

Top of Page Top of Page

 
 
Applies to:
Excel 2007, Outlook 2007, PowerPoint 2007, Word 2007