How To Change The Text In A Legend In Excel

Download Article

Download Article

This wikiHow teaches y'all how to alter the proper noun or value of a chart's legend entries in a Microsoft Excel spreadsheet, using a computer.

Steps Download Article

1. 1

   Open up the Excel spreadsheet file you desire to edit. Find the spreadsheet yous desire to edit on your computer, and double-click on its icon to open the worksheet.

2. 2

   Click on the chart y'all want to edit. Discover the chart you want to modify in your spreadsheet, and click on it to select the nautical chart.

   • This will brandish your nautical chart tool tabs at the top of your spreadsheet, such as Design, Layout, and Format

   Advert

3. three

   Click the Design tab. Yous can find information technology at the pinnacle of Excel's toolbar ribbon. It volition brandish your chart blueprint tools on the toolbar.

   • Depending on your version of Excel, this tab may be named Chart Design.

4. iv

   Click Select Data in the Design toolbar. This will open a new dialogue box where you can edit your legend and data values.

5. 5

   Select a fable entry in the "Legend entries (Series)" box. This box lists all the legend entries in your chart. Notice the entry y'all want to edit here, and click on information technology to select information technology.

6. half-dozen

   Click the Edit button. This will let you to edit the selected entry's name and information values.

   • On some versions of Excel, you won't come across an Edit button. In this case, y'all can skip this step, and wait for the Name or Series Name field in the same dialogue box.

7. 7

   Type in a new entry name into the Series Proper name box. Double-click the text field, delete the current name, and enter the proper noun 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 tin can click the Collapse Dialogue icon, and select a prison cell from the spreadsheet. This volition copy and assign the selected cell's contents every bit the entry name.

8. 8

   Enter a new chart value into the Y values box. Y'all can delete the selected entry's electric current value here, and type in a new value to change your chart.

   • If you lot have multiple Y output categories in your chart, such as multiple bars, brand sure to use a comma to separate each value here.
   • Alternatively, yous 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. 9

   Click the OK button. This will save your name and value edits, and apply the changes to your visual chart.

   Advertizing

Ask a Question

200 characters left

Include your e-mail address to get a message when this question is answered.

Submit

Advertizement

Cheers for submitting a tip for review!

Well-nigh This Commodity

Article Summary X

i. Open a spreadsheet, and click the chart you want to edit.
two. Click the Design or Chart Design tab.
3. Click Select Information on the toolbar.
4. Select a legend entry, and click Edit.
five. Enter a new name into the Series Name or Name box.
half dozen. Enter a new value into the Y values box.
7. Click OK.

Did this summary help you lot?

Thanks to all authors for creating a folio that has been read 43,809 times.

Is this article up to date?

Source: https://www.wikihow.com/Edit-Legend-Entries-in-Excel

Posted by: brownarand1988.blogspot.com

Share this post