WallStreetMojo

WallStreetMojo

WallStreetMojo

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

Excel Chart Legend

Chart Legend in Excel

A legend is a description of major elements of an excel chart. It helps in easy access of any chart. They are usually represented by colors or symbols. In this article, we will learn about Legend and its uses with the help of the examples.

How to Add a Legend to Excel Chart?

You can download this Chart Legend Excel Template here – Chart Legend Excel Template

Example #1 – Change Order of Legend

For instance, there is a range of Products that a company ABC sells, and after a few days of selling the product, the company seeks reviews from its customers by asking them to rate the product on 10.

Since the company is dealing with multiple products and is trying to make a place in the market, it keeps track of each customer and their ratings as follows.

Excel Chart Legend Example.1

In the above example, we have taken only ten customers for ease of understanding. However, a company may have multiple customers for a single product.

With the use of Excel legends, we can understand the products and their ratings in a better way.

  • In an excel file, we have Option Insert, and on the right side outlined in black, the following options for the charts would be given. We can choose from a range of charts that is from Recommended Charts to Scatter charts or a simple one.

Example.1.1

  • For the convenience of explanation and understanding, we have selected one of the basic charts as follows.

Excel Chart Legend Example.1.2

  • We will have a chart like the below one.

Example.1.3

  • As soon as the chart is selected, we will be navigated automatically to the design option for formatting. Here in the example, we have chosen the first design. And, we can edit the design any number of times, even after the final chart and legend adjustments are done.

Excel Chart Legend Example.1.4

In the Design Option, we have an icon of Add Chart Element on the left side of the sheet, as highlighted below. When we click on that, we get a pop-down menu, as you can see below. The pop-down menu has an option – Legend, as shown below.

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

Example.1.5.0

  • To bring the Legend on the Chart, we go to the Chart Tools – Design – Add chart element – Legend – Top.

Excel Chart Legend Example.1.6

  • As soon as we do this, there appears an extra element on the chart shown as follows.

Example.1.7

This is a Legend. A legend gives us a direction as to what is marked in the chart in blue color. In our example, it is the Ratings from customers.

The above process looks simple. Let me guess what you are thinking!

Why this?

This may look simple. However, as I mentioned earlier, a company may have several customers for a single product, or there may be several products in an organization with a different class of customers.

As you might have observed that in the above example, we have taken just one simple Rating!

Example #2 – Change Format of Legend

However, to explain it better, let us take another example of multiple data elements to make a chart of three different products, as mentioned on the next page.

The following is a list of customers and their sales values for each product.

Excel Chart Legend Example.2

When we make a chart for this following the above procedures, then our graph will look like this. And the Legend will be represented by different colors as represented by the arrow that is Blue for Burger, Orange for Fries, and Green for Noodles.

Example.2.1

We can customize the legends as per the explanation above and can select from a range of options to make any alterations. As you can see, the legend is at the top of the chart. We can edit it to bring it to Top, Bottom, Right, or Left as per the need and convenience.

  • Moving ahead with the Legends, when we double click on the legends part of the chart as shown with an arrow, then we get Format Legend Option.

Excel Chart Legend Example.2.2.0

  • The Format Legend Option Area has 3 icons, as shown below.

 Example.2.3.0

  • From the Icon Legend Options as mentioned in the above screenshot, we can select from various options to adjust the chart that is Top, Bottom, Left, Right, Top right. For instance, here we have changed the option to left. Now my chart looks as follows. The legend appears on the left side now.

Excel Chart Legend Example.2.5

  • Meanwhile, we also have the option to change the color of the Legends. Go to Design – Click on Change colors in the drop-down menu. We have the option of changing the colors of our Legends.

 Example.2.6

  • The new chart looks like the following:

Excel Chart Legend Example.2.7

  • We also have the option of changing the names of the Legend. Go to the option Chart Filters. It helps to edit and modify the names and areas of the Chart elements. Then click on Select Data as highlighted below in red.

 Example.2.8

  • When we select the above option, a pop-up menu called the Select Data Source screen appears as follows. There is an option of Edit.

Excel Chart Legend Example.2.9

  • The below-mentioned screenshot is the next step where the Edit Series with “Burger” comes under the Series Name. Here we have the option of editing the Name of the Legend.

 Example.2.10

  • We have replaced the name “Burger” with another name, “Ham Burger,” and then click OK.

Excel Chart Legend Example.2.11

  • The chart looks like this now.

Example.2.12

  • In the same way, we can edit and replace the names of the Legends as per the needs.

Conclusion

  • Legends may occupy a very small cornered area in any Chart of an Excel sheet; however, it is one of the most important areas.
  • It characterizes the units of any chart in the best possible way with the required details for the viewers. It can be customized as per the needs.
  • It makes the presentation easier and better.
  • The Legends are used for analyzing the data in a better way compared to normal tabular contents.
  • It helps in comparison to multiple data and assists in better understanding of the data.
  • It is one of the most important parts of any chart and is present in all of them.

Recommended Articles

This has been a guide to Excel Chart Legend. Here we discuss how to add and format legends in the Excel chart along with examples and a downloadable excel template. You may learn more about excel from the following articles –

  • Chart Wizard in Excel
  • Power BI Pie Chart
  • Interactive Chart in Excel
  • Power BI Charts
  • Spell Check in Excel
0 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 Chart Legend Excel Template

New Year Offer - All in One Financial Analyst Bundle (250+ Courses, 40+ Projects) View More