Download Article
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.
Steps
Download Article
-
Open the Excel spreadsheet file you want to edit. Find the spreadsheet you want to edit on your computer, and double-click on its icon to open the worksheet.
-
Click on the chart you want to edit. 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 -
Click the Design tab. 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 .
-
Click Select Data in the Design toolbar. This will open a new dialogue box where you can edit your legend and data values.
-
Select a legend entry in the "Legend entries (Series)" box. 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.
-
Click the Edit button. 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.
-
Type in a new entry name into the Series Name box. 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.
-
Enter a new chart value into the Y values box. 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.
-
Click the OK button. This will save your name and value edits, and apply the changes to your visual chart.
Advertisement
Expert Q&A
Ask a Question
200 characters left
Include your email address to get a message when this question is answered.
Submit
Advertisement
Tips
Submit a Tip
All tip submissions are carefully reviewed before being published
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 56,874 times.
Advertisement
