Download ArticleDownload ArticleThis article was co-authored by How.com.vn Staff. Our trained team of editors and researchers validate articles for accuracy and comprehensiveness. How.com.vn's Content Management Team carefully monitors the work from our editorial staff to ensure that each article is backed by trusted research and meets our high quality standards.
The How.com.vn Tech Team also followed the article's instructions and verified that they work.
This article has been viewed 56,128 times.
Learn more...
This How.com.vn 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.
Expert Q&A
Tips
About This Article
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.
Is this article up to date?
⚠️ Disclaimer:
Content from Wiki How English language website. Text is available under the Creative Commons Attribution-Share Alike License; additional terms may apply.
Wiki How does not encourage the violation of any laws, and cannot be responsible for any violations of such laws, should you link to this domain, or use, reproduce, or republish the information contained herein.
- - A few of these subjects are frequently censored by educational, governmental, corporate, parental and other filtering schemes.
- - Some articles may contain names, images, artworks or descriptions of events that some cultures restrict access to
- - Please note: Wiki How does not give you opinion about the law, or advice about medical. If you need specific advice (for example, medical, legal, financial or risk management), please seek a professional who is licensed or knowledgeable in that area.
- - Readers should not judge the importance of topics based on their coverage on Wiki How, nor think a topic is important just because it is the subject of a Wiki article.
