FLASH SALE! - "CHATGPT AND ARTIFICIAL INTELLIGENCE FOR MICROSOFT EXCEL AT 60% OFF" Enroll Now

Legends In Excel Chart

Updated on December 28, 2023
Article byWallstreetmojo Team
Edited byNannila Jai Ratna
Reviewed byDheeraj Vaidya, CFA, FRM

What Are Legends In Excel Chart?

Legends in excel chartLegends In Excel ChartExcel chart legends depict description of significant elements and provides easy access to any chart. These legends are represented with the help of colours or symbols and distinguish data for better understanding.read more are a representation of data itself. It is used to avoid confusion when the data has the same values in all the categories. In addition, it is used to differentiate the classes, which helps the user or viewer to understand the data more properly. It is located on the right-hand side of the given Excel chart.

For example, consider the below image showing population of people in a place under 25, divided by directions.

Legends in excel Charts - Intro.jpg

Though this chart type is neat and clean, we need to have legends to make it more presentable and understandable.

To insert, simply click on the chart and click on the ‘+’ symbol. Now, select the Legend option.

We can see from the below image that the legends are added in Excel.

Legends in excel Charts - Intro - legends

Likewise, we can use legends in Excel.

Let’s understand more about legends in Excel in this article with detailed examples.

Key Takeaways

  • Legends in Excel chart are a small visual representation of the chart’s data series to understand each without confusion.
  • Legends are directly linked to the chart data range and change accordingly.
  • In simple terms, if the data includes many colored visuals, legends show what each visual label means.
  • To insert legends in Excel chart, simply click on the chart which we have created and then, click on ‘+’ option.
  • Now, select the Legend option. We can immediately see the legends in Excel chart.

Explanation And Uses

If you look at the below image of the graph, the graph represents each year’s region-wise sales summary. So in a year, we have four zones: each year, the red color represents the North zone, the orange color represents the East zone, the green color represents the South zone, and light blue represents the West zone.

In this way, legends are useful in identifying the same set of data series in different categories.

Legends in Excel Chart

You are free to use this image on your website, templates, etc, Please provide us with an attribution linkHow to Provide Attribution?Article Link to be Hyperlinked
For eg:
Source: Legends In Excel Chart (wallstreetmojo.com)

–>> If you want to learn Excel and VBA professionally, then ​Excel VBA All in One Courses Bundle​ (35+ hours) is the perfect solution. Whether you’re a beginner or an experienced user, this bundle covers it all – from Basic Excel to Advanced Excel, Macros, Power Query, and VBA.

How To Add Legends To A Chart In Excel?

Below are a few examples of adding legends in Excel.

You can download this Add Legends to Chart Excel Template here – Add Legends to Chart Excel Template

Examples

Example #1 – Work with Default Legends In Excel Charts

When you create a chart in excelCreate A Chart In ExcelIn Excel, a graph or chart lets us visualize information we've gathered from our data. It allows us to visualize data in easy-to-understand pictorial ways. The following components are required to create charts or graphs in Excel: 1 - Numerical Data, 2 - Data Headings, and 3 - Data in Proper Order.read more, we see legends at the bottom of the chart below the X-axis.

legends example 1.1

The above chart is a single legend, i.e., in each category, we have only one set of data, so there is no need for legends here. But, in the case of multiple items in each category, we have to display legends to understand the scheme of things.

For example, look at the below image.

legends example 1.2

Here 2014, 2015, 2016, 2017, and 2018 are the main categories. Under these categories, we have sub-categories that are common for all the years, i.e., North, East, South, and West.

Example #2 – Positioning Of Legends In Excel Charts

As we have seen, by default, we get legends at the bottom of every chart. But that is not the end; we can adjust it to the left, right, top, right, and bottom.

For changing the positioning of the legends in Excel 2013 and later versions, there is a small PLUS button on the right-hand side of the chart.

example 1.3

If we click on that PLUS icon, we will see all the chart elements.

example 1.4

Here we can change, enable, and disable all the chart elements. Now, go to Legend and place a cursor on the legend; we will see Legend options.

example 1.5

It is showing as Bottom, i.e., legends are showing at the bottom of the chart. You can change the position of the legend as per your wish.

The below images will display the different positioning of the legend.

Legend at Right Side

Click on the “Right” option in “Legend.”

example 1.6

We will see the legends on the right-hand side of the graph.

example 1.7

Legends at the top of the chart

Select the “Top” option from the “Legend,” and we may see the legends at the chart’s top.

Legends at the top of the chart

Legends at the Left Side of the chart

Select the “Left” option from the “Legend,’ and we may see the legends on the left side of the chart.

Legends at the Left Side of the chart

Legends at the Top Right Side of the Chart

Go to “More Options,” select the “Top Right” option, and see the following result.

Legends at the Top Right Side of the Chart

If you are using Excel 2007 and 2010, the positioning of the legend will not be available, as shown in the above image. Instead, select the chart and go to “Design.”

Under Design, we have the Add Chart Element.

add chart element

Click on the drop-down list of Add Chart Element > Legends > Legend Options.

drop-down list of Add Chart Element

In the above tool, we need to change the legend positioning.

Example #3 – Excel Legends Are Dynamic

Legends are dynamic in Excel as formulas. Since the legends are directly related to the data series, any changes made to the data range will affect legends directly.

For example, look at the chart and legends.

legends example 2.3

We will change the “North” zone’s color to “red” and see the impact on legends.

legend example 2.4

Legends’ indication color has also changed to red color automatically.

We will change the North zone to India in the Excel cell for experiment purposes.

legends example 2.5

Now see what the legend name is.

legends example 2.6

It automatically updated the legend name from North to INDIA. These legends are dynamic if directly referred to as the data series range.

Important Things To Note

  • Legends are representation of data, found in the chart created in Excel.
  • By default, we get legends at the bottom.
  • Legends are dynamic and change as per the change in color and text.

Frequently Asked Questions (FAQs)

1. What is legends in Excel?

Legends are representation of data. Users use them to make the data more presentable and to avoid confusion. Based on the chart types, we can choose whether or not to include legends in Excel.

2. Explain overlapping of legends in Excel chart with an example.

By default, legends will not overlap other chart elements, but if space is too constrained, they will overlap on other chart elements. Below is an example of the same.

legends example 3.1

In the above image, legends are overlapped on the X-axis. To make it proper, go to legends and check the option “Show the legend without overlapping the chart.”

It will separate the legends from other chart elements and show them differently.

legends example 3.3

3. What are some important points to remember while using legends in Excel?

Legends are available by default and we can choose whether or not to include legends in Excel chart.

Also, we can change the positioning of the legend as per our wish but cannot place it outside the chart area.

This article is a guide to Legends in Excel Chart. We discuss adding legends in Excel with examples and downloadable Excel templates. You may also look at these useful functions in Excel: –

Reader Interactions

Leave a Reply

Your email address will not be published. Required fields are marked *