WallStreetMojo

WallStreetMojo

WallStreetMojo

MENUMENU
  • Free Tutorials
  • Certification Courses
  • Excel VBA All in One Bundle
  • Login
Home » Excel, VBA & Power BI » Excel Tutorials » Legends in Excel Chart

Legends in Excel Chart

Legends in excel chart are basically representation of data itself, it is used to avoid any sorts of confusion when the data has the same type of values in all the categories, it is used to differentiate the categories which help user or viewer to understand the data more properly, it is located on the right-hand side of the given excel chart.

Add Legends to Excel Charts

Legends are a small visual representation of the chart’s data series to understand each data series without any sort of 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.

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

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

With regards to legends, we are covering all the things you need to know about the excel chart legends; follow this article to know the ins and outs of legends.

add legends to chart

How to Add Legends to Chart in Excel?

Below are the few examples to add legends in excel.

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

Example #1 – Work with Default Legends in Excel Charts

When you create a chart in excel, we see legends at the bottom of the chart just 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 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 of it; we can adjust it to the left, right, top, top right, and bottom.

Popular Course in this category
Sale
All in One Excel VBA Bundle (35 Courses with Projects)
4.9 (1,353 ratings)
35+ Courses | 120+ Hours | Full Lifetime Access | Certificate of Completion
View Course

In order to change the positioning of the legend in excel 2013 and later versions, there is a small PLUS button on the right-hand side of the chart.

example 1.3

If you 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

Right now, 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

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

example 1.7

Legends at the top of the chart

Select Top option from the Legend, and you will see the legends at the top of the chart.

Legends at the top of the chart

Legends at the Left Side of the chart

Select the Left option from the Legend, and you will 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 you will see the result as follows.

Legends at the Top Right Side of the Chart

If you are using Excel 2007 & 2010, positioning of legend will not be available, as shown in the above image. 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 in Nature

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

Now I 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 automatically.

Now for experiment purposes, I will change the North zone to India in the excel cell.

legends example 2.5

Now see what the legend name is.

legends example 2.6

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

Example #4 – Overlapping of Legends in Excel Chart

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

overlapping of legends

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

format legend

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

legends example 3.3

Things to Remember While Adding Legends in Excel

Below are a few things to remember.

  • By default, we get legends at the bottom.
  • Legends are dynamic and change as per the change in color and text.
  • We can change the positioning of the legend as per our wish but cannot place outside the chart area.

Recommended Articles

This has been a guide to Legends in Excel Chart. Here we discuss how to Add Legends in Excel with examples and downloadable excel templates. You may also look at these useful functions in excel –

  • Chart Templates in Excel
  • Excel Chart Wizard
  • Create a Line Chart in Excel
  • Histogram Excel Chart
1 Shares
Share
Tweet
Share
All in One Excel VBA Bundle (35 Courses with Projects)
  • 35+ Courses
  • 120+ Hours
  • Full Lifetime Access
  • Certificate of Completion
LEARN MORE >>
Primary Sidebar
Footer
COMPANY
About
Reviews
Contact
Privacy
Terms of Service
RESOURCES
Blog
Free Courses
Free Tutorials
Investment Banking Tutorials
Financial Modeling Tutorials
Excel Tutorials
Accounting Tutorials
Financial Statement Analysis
COURSES
All Courses
Financial Analyst All in One Course
Investment Banking Course
Financial Modeling Course
Private Equity Course
Venture Capital Course
Excel All in One Course

Copyright © 2021. CFA Institute Does Not Endorse, Promote, Or Warrant The Accuracy Or Quality Of WallStreetMojo. CFA® And Chartered Financial Analyst® Are Registered Trademarks Owned By CFA Institute.
Return to top

WallStreetMojo

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

* Please provide your correct email id. Login details for this Free course will be emailed to you

Book Your One Instructor : One Learner Free Class
Let’s Get Started
Please select the batch
Saturday - Sunday 9 am IST to 5 pm IST
Saturday - Sunday 9 am IST to 5 pm IST

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

WallStreetMojo

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

* Please provide your correct email id. Login details for this Free course will be emailed to you

Login

Forgot Password?

WallStreetMojo

Download Add Legends to Chart Excel Template

New Year Offer - All in One Excel VBA Bundle (35 Courses with Projects) View More