How to Edit Legend in Excel


Legends are routinely created for every chart you insert into your Excel workbooks. They’re the important thing to understanding how your chart reads and what data is depicted.
how to add legend to excel

In charts with legends displayed, you might edit the person legend entries on the worksheet by enhancing the corresponding knowledge. Change the legend particulars within the Choose Information Supply dialog field for additional customization choices. This additionally ensures you may alter legend entries with out influencing the worksheet knowledge.

This text works for all software program variations and platforms, nevertheless, we’ll be utilizing the most recent Microsoft Excel 2019 for Home windows 10.

Fast tip: How one can add a legend to my Excel chart?

When you don’t know easy methods to add a legend to your charts in Excel, right here’s a fast tutorial. Subsequent, you may learn to modify this legend each within the worksheet or independently within the chart.

  1. Choose the chart you wish to add a legend to. This could open the Design tab in your ribbon interface, which is often hidden.
  2. Click on on the Design tab within the ribbon, after which click on on the Add chart component.
    how to add legend into excel chart
  3. Hover your mouse over Legend, after which select the kind of legend you wish to add to your chart. Moreover, if you wish to take away the legend, merely click on None.
    how to add legend into excel chart
  4. Accomplished!

How one can change legend entries in Excel

Beneath, you’ll find the present working strategies of enhancing your chart legend in Excel, appropriate for various approaches. Determine whether or not you wish to alter your knowledge, or just wish to modify the legend labels themselves, and proceed with the suitable information.

Want any assist? Don’t hesitate to contact us for fast, professional help for all Microsoft Workplace merchandise.

Methodology 1. Edit legend entries in your worksheet

If you wish to modify the info cell in addition to the legend that will get displayed on the chart, you are able to do so by enhancing the legend entry in your worksheet. To do that, comply with the steps under.

  1. Click on the cell in your worksheet that accommodates the info that seems as an entry within the chart legend. In our instance, the legend entry is “Gross sales” so we’ll be choosing the B1 cell:
    edit legend entries in your worksheet
  2. Begin typing to switch the cell, and sort within the new desired title on your legend entry. Press Enter in your keyboard while you’re finished modifying the cell. 
    edit legend
    Imgur hyperlink
  3. The change will routinely replicate in your chart, and the brand new legend title will seem within the legend on the chart.

Methodology 2. Use the Choose Information Supply function

The choice technique of enhancing your chart legend is utilizing a function referred to as Choose Information Supply. By following the steps under, you may alter the legend entry with out having to switch the unique cell in your worksheet.

  1. Choose the chart you wish to add a legend to. This could open a few of the tabs in your ribbon interface that are hidden by default.
  2. Change to the newly seen Design tab in your ribbon interface. Click on on the Choose Information button from the Information group.
    use the select data source feature to edit legend
  3. A brand new pop-up window ought to seem. Right here, search for a field referred to as Legend Entries (Collection) after which choose the legend you wish to modify. In our instance, we’ll be enhancing the “Gross sales” legend.
  4. Click on on the Edit button.
    use the select data source feature to edit legend
  5. Use the Collection Identify enter field to do one of many following: 
    1. Kind the legend entry title that you simply wish to use. This will likely be a static title that it’s essential to change manually, even when the unique cell is altered. 
    2. Kind the reference to the worksheet cell that accommodates the info that you simply wish to use because the legend title. That is dynamic, which means that you simply solely want to switch the cell title to replicate modifications within the chart.
  6. Press Enter after enhancing the legend entry. Click on OK to shut the Choose Information Supply window.
    use the select data source feature to edit legend
  7. Accomplished!

Ultimate ideas

We hope that this text helped you learn to edit a legend in Excel and modify chart legends. Now, you may hold your charts dynamic and up-to-date together with your knowledge, irrespective of what number of modifications are made.

Earlier than you go

When you want any additional assist with Excel, don’t hesitate to succeed in out to our customer support crew, accessible 24/7 to help you. Return to us for extra informative articles all associated to productiveness and modern-day expertise!

When you appreciated this join our publication to obtain the most recent expertise information in your inbox and be the primary to learn our tricks to turn into extra productive in addition to our promotions, offers, and reductions on our merchandise for one of the best price. Enter your e mail right here under.

You may additionally like

» What Model of Excel Do I Have?
» How one can Separate First and Final Identify in Excel
» How To Print Gridlines in Excel

NOTE : Please do not copy -
See also  Google Chrome Doesn’t Respond On Clicking

Leave a Reply