Understand the Legend and Legend Key in Excel Spreadsheets GA S REGULAR Menu Lifewire Tech for Humans Newsletter! Search Close GO Software & Apps > MS Office

Understand the Legend and Legend Key in Excel Spreadsheets

By Ted French Ted French Writer Former Lifewire writer Ted French is a Microsoft Certified Professional who teaches and writes about spreadsheets and spreadsheet programs. lifewire's editorial guidelines Updated on September 11, 2020 Reviewed by Lisa Mildon Reviewed by Lisa Mildon Southern New Hampshire University Lisa Mildon is a Lifewire writer and an IT professional with 30 years of experience. Her writing has appeared in Geekisphere and other publications. lifewire's editorial guidelines Tweet Share Email Tweet Share Email MS Office Excel Word Powerpoint Outlook In a chart or graph in a spreadsheet program such as Microsoft Excel, the legend is often located on the right-hand side of the chart or graph and is sometimes surrounded by a border. The legend is linked to the data being graphically displayed in the plot area of the chart. Each specific entry in the legend includes a legend key for referencing the data. The information in this article applies to Excel 2019, 2016, 2013, Excel for Mac, and Excel Online.

What Are Legend Keys

To add to the confusion between legends and keys, Microsoft refers to each individual element in a legend as a legend key. A legend key is a single colored or patterned marker in the legend. To the right of each legend key is a name identifying the data represented by the specific key. Lifewire. Depending on the type of chart, the legend keys represent different groups of data in the accompanying worksheet: Line Graph, Bar Graph, or Column Chart: Each legend key represents a single data series. For example, in a column chart, there might be a blue legend key that reads Favorite Snacks Votes next to it. The blue colors in the chart refer to the votes for each entry in the Snacks series. Pie Chart or Circle Graph: Each legend key represents only a portion of one data series. To use the same example from above, but for a pie chart, every cut of the pie is a different color that represents each "Snacks" entry. Every portion of the pie is a different size of the whole circle to represent the vote differences taken from the "Votes" series.

Editing Legends and Legend Keys

In Excel, legend keys are linked to the data in the plot area, so changing the color of a legend key will also change the color of the data in the plot area. You can right-click or tap-and-hold on a legend key, and choose Format Legend, to change the color, pattern, or image used to represent the data. Lifewire. To change options related to the whole legend and not just a specific entry, right-click or tap-and-hold to find the Format Legend option. This is how you change the text fill, text outline, text effect, and text box.

How to Show the Legend in Excel

After making a chart in Excel, it's possible that the legend doesn't automatically show. You can enable the legend by simply toggling it on. Here's how: Select your existing chart. Select Design. Select Add Chart Element. Select Legend. Choose where the legend should be placed — right, top, left, or bottom. There's also a More Legend Options > Top Right if you prefer. If the option to add a legend is grayed out, it just means that you need to select data first. Right-click the new, empty chart and choose Select Data, and then follow the on-screen instructions to choose the data that the chart should represent. Was this page helpful? Thanks for letting us know! Get the Latest Tech News Delivered Every Day Subscribe Tell us why! Other Not enough details Hard to understand Submit More from Lifewire How to Create Exploding Pie Charts in Excel How to Use Google Sheets How to Create a Report in Excel How to Hide and Unhide Columns, Rows, and Cells in Excel How to Make a Bar Graph in Excel How to Limit Rows and Columns in an Excel Worksheet How to Create an 8 Column Chart in Excel How to Make a Chart on Google Docs Use Office Clipboard to Copy Multiple Items in Excel How to Make a Graph in Google Sheets Understanding Excel Chart Data Series, Data Points, and Data Labels How to Create a Graph in Microsoft Word Plot Area in Excel and Google Spreadsheets How to Add a Secondary Axis in Excel How to Create a Histogram in Excel for Windows or Mac The Do's and Don'ts of Entering Data in Excel Newsletter Sign Up Newsletter Sign Up Newsletter Sign Up Newsletter Sign Up Newsletter Sign Up By clicking “Accept All Cookies”, you agree to the storing of cookies on your device to enhance site navigation, analyze site usage, and assist in our marketing efforts. Cookies Settings Accept All Cookies