PDF download Download Article PDF download Download Article

This wikiHow teaches you how to change the name or value of a chart's legend entries in a Microsoft Excel spreadsheet, using a computer.

  1. Find the spreadsheet you want to edit on your computer, and double-click on its icon to open the worksheet.
  2. Find the chart you want to modify in your spreadsheet, and click on it to select the chart.
    • This will display your chart tool tabs at the top of your spreadsheet, such as Design , Layout , and Format
    Advertisement
  3. You can find it at the top of Excel's toolbar ribbon. It will display your chart design tools on the toolbar.
    • Depending on your version of Excel, this tab may be named Chart Design .
  4. This will open a new dialogue box where you can edit your legend and data values.
  5. This box lists all the legend entries in your chart. Find the entry you want to edit here, and click on it to select it.
  6. This will allow you to edit the selected entry's name and data values.
    • On some versions of Excel, you won't see an Edit button. In this case, you can skip this step, and look for the Name or Series Name field in the same dialogue box.
  7. Double-click the text field, delete the current name, and enter the name you want to assign to this entry in your chart's legend.
    • This box may also be labeled as Name instead of Series Name.
    • Alternatively, you can click the Collapse Dialogue icon, and select a cell from the spreadsheet. This will copy and assign the selected cell's contents as the entry name.
  8. You can delete the selected entry's current value here, and type in a new value to change your chart.
    • If you have multiple Y output categories in your chart, such as multiple bars, make sure to use a comma to separate each value here.
    • Alternatively, you can click the Collapse Dialogue icon, and select a cell or multiple cells from the spreadsheet to import the cell values into your chart.
  9. This will save your name and value edits, and apply the changes to your visual chart.
  10. Advertisement

Expert Q&A

Ask a Question
      Advertisement

      Tips

      Submit a Tip
      All tip submissions are carefully reviewed before being published
      Name
      Please provide your name and last initial
      Thanks for submitting a tip for review!

      About This Article

      Article Summary X

      1. Open a spreadsheet, and click the chart you want to edit.
      2. Click the Design or Chart Design tab.
      3. Click Select Data on the toolbar.
      4. Select a legend entry, and click Edit .
      5. Enter a new name into the Series Name or Name box.
      6. Enter a new value into the Y values box.
      7. Click OK .

      Did this summary help you?
      Thanks to all authors for creating a page that has been read 58,720 times.

      Is this article up to date?

      Advertisement