EDUCBA

EDUCBA

MENUMENU
  • Free Tutorials
  • Certification Courses
  • 120+ Courses All in One Bundle
  • Login
Home Excel Excel Resources Excel Charts Legends in Chart
Secondary Sidebar
Excel Functions
  • Excel Charts
    • Excel Data Visualization
    • Dashboard in Excel
    • Bullet Chart in Excel
    • Excel Animation Chart
    • Plots in Excel  
    • Interactive Chart in Excel
    • Surface Charts in Excel
    • Excel Calendar Template
    • Thermometer Chart in Excel
    • Box Plot in Excel
    • S CURVE in Excel
    • Venn Diagram in Excel
    • Project Management with Gantt Chart
    • Change Chart Style in Excel
    • 3D Scatter Plot in Excel
    • Box and Whisker Plot in Excel
    • Radar Chart in Excel
    • Control Charts in Excel
    • Dot Plots in Excel
    • Marimekko Chart Excel
    • Combo Chart in Excel
    • Contour Plots in Excel
    • Candlestick Chart in Excel
    • Map Chart in Excel
    • Pie Chart Examples
    • Excel Stacked Bar Chart
    • Excel Flowchart
    • Excel Types of Graphs
    • Excel Normal Distribution Graph
    • Excel Bell Curve
    • Legends in Excel Chart
    • Excel Chart Templates
    • Excel Organization Chart
    • Excel Doughnut chart
    • Excel 3D Plot
    • Excel Scatter Chart
    • Excel Line Chart
    • Excel Combination Charts
    • Excel Gauge Chart
    • Excel Pivot Chart
    • Excel Clustered Column Chart
    • Excel Dynamic Chart
    • Excel Stacked Column Chart
    • Excel Bubble Chart
    • Histogram Chart Excel
    • Excel Gantt Chart
    • Excel Stacked Area Chart
    • Excel Waterfall Chart
    • Excel Area Chart
    • Excel Clustered Bar Chart
    • Excel Column Chart
    • Excel Pie Chart
    • Comparison Chart in Excel
    • Pareto Analysis in Excel
    • Add a Secondary Axis in Excel
    • Grouped Bar Chart
  • Excel Functions (12+)
  • Excel Tools (114+)
  • Financial Functions in Excel (17+)
  • Logical Functions in Excel (14+)
  • Lookup and Reference Functions in Excel (35+)
  • Maths Function in Excel (47+)
  • TEXT and String Functions in Excel (26+)
  • Date and Time Function in Excel (24+)
  • Statistical Functions in Excel (59+)
  • Information Functions in Excel (4+)
  • Excel Tips (222+)
  • Workplace Productivity (4+)
  • Microsoft Office Tools (15+)
  • Excel Formula and Functions (22+)
  • MS Excel Shortcuts (4+)
Excel Functions Courses
  • EXCEL ADVANCED COURSE
  • Excel Data Analysis Course
  • Excel for Marketing Course

Legends in Chart

By Arun GuptaArun Gupta

Legend in Excel Chart

Excel Chart Legends (Table of Contents)

  • Legends in Chart
  • How to Remove a Legend in Excel?
  • How to Add a Legend in Excel?
  • How to Change the Position of Legend?
  • How to Edit the Legend Text in Chart?

Legends in Chart

Before seeing how to add the legend and change the legend positions, we will first understand what legend is.

Legend

A Legend is a representation of legend keys or entries on the plotted area of a chart or graph, which are linked to the data table of the chart or graph. By default, it may show on the bottom or right side of the chart. The data in a chart is organized with a combination of Series and Categories. Select the chart and choose filter then you will see the categories and series.

Start Your Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

Each legend key will represent a different color to differentiate from the other legend keys.

Different Actions on Legends

Now we will create a small chart and perform different actions on legends. Consider a small table which represents the sales of A and B for the year 2011, 2012 and 2013.

Sales Table

We will insert a chart by selecting the data and clicking on the Insert menu button at the top. After that, select the Recommended charts option.

select Recommended charts option

The below-suggested chart box will open. Choose any one chart from the available charts. Here we have selected the first chart.

All in One Excel VBA Bundle(120+ Courses, 30+ Projects)
Basic ExcelAdvanced ExcelVBA & MacrosExcel Dashboards
Pivot TablesStatistical FunctionsFinancial FunctionsCharts & Graphs
Price
View Courses
120+ Online Courses | 30+ Projects | 500+ Hours | Verifiable Certificates | Lifetime Access
4.9 (64,639 ratings)

Legend in Excel 1-3

Then the chart will appear as below.

Chart Output

In the below chart, the keys A and B are highlighted with a red color box which is called Legend.

Legend

The Legend will be created automatically when we create a chart in excel. If we observe, A and B represent two different colors, and the bars also represent the same color for 2011,2012 and 2013.

Here legend keys are vertical series of data. If we place the cursor on the legend keys, it will pop up the message.

Legend in Excel 1-6

How to Remove a Legend in Excel?

Suppose we want to remove the legend from the chart. Follow the below steps.

You can download this Legend Chart Excel Template here – Legend Chart Excel Template
  • Click on the chart so that it will be highlighted as below. Click on the “+” symbol on the top right-hand side of the chart.

Click on Plus symbol

  • It will give a popup menu with multiple options as below. By default, Legend will be select with a tick mark.

Legend in Excel 2-2

  • If we want to remove the Legend, remove the tick mark for Legend.

Untick Legend

  • We removed the tick mark; hence the Legend is removed from the chart we can observe in the below picture.

Result

How to Add a Legend in Excel?

If we want to add the legend in the excel chart, it is a quite similar way how we remove the legend in the same way.

  • Select the chart and click on the “+” symbol at the top right corner.

Legend in Excel 3-1

  • From the pop-up menu, give a tick mark to the Legend.

Legend in Excel 3-2

  • Now Legend is available again.

Legend in Excel 3-3

  • If we observe, the legend is now available on the right-hand side before it was at the bottom of the chart.

How to Change the Position of Legend in Chart?

Now we will see how to keep the Legend in the excel chart at the required location.

  • Select the chart as usual. Click on the “+” symbol.

Legend in Excel 4-1

  • From the pop-up menu, there is an arrow directing towards the right when you choose legend if we observe. Click on the right arrow.

Click on the right arrow

  • A drop-down will appear.

Legend in Excel 4-3

  • As our Legend is now on the right side, the “Right” option is highlighted when we open it. Suppose we want to keep the legend on the Top select Top similarly as Right, Left, and Bottom. In this example, we will choose the Top option.

Choose Top option

  • Hence it moved to the top as below.

Legend in Excel 4-5

  • Up to now, the Legend always appears separately from the chart. If we want to overlap the legend on the chart, then click on the More options available on the Legend.

Legend in Excel 4-6

  • When we click on More options, on the right side format menu for legend will appear. Show the legend without overlapping the chart option is available with a tick mark at the bottom of the Format legend.

Legend in Excel 4-7

  • If we want to remove the tick mark, click on it.

Legend in Excel 4-8

  •  Then the Legend will overlap with the chart as below image.

Legend in Excel 4-9

How to Edit the Legend Text in Chart?

In case if we want to replace A with XYZ and B with ABC but without changing the data in the table, then, in that case, we can edit the Legend text.

  • Select the chart and select the Filter on the right-hand side of the chart.

Legend in Excel 5-1

  • If we want to edit the text of A to XYZ, then keep the cursor on A and choose the “Edit series” option while mouse pointing on A. Now click on Edit series.

Legend in Excel 5-2

  • An Edit series dialog box will appear as below.

Edit series dialog box

  • It has a series name address and a series value address. As we want to change the series name to XYZ, change the name to XYZ and then click on OK.

Legend in Excel 5-4

  • The column name remains the same as A, but it is changed to XYZ on the chart.

Legend in Excel 5-5

  • If we want to give the border to the legend, we can give it by using “Format legend”. Under the border option, select the Solid Line then it will create a border for the Legend.

Select Border

  • Suppose we want to give the background to the Legend. Click on the “Fill” drop-down and select the options Solid Fill.

Change Color

  • We can give the required color by changing the color option, which is marked in the above image. Instead of color, we can also select Gradient fill, Pattern fill, and picture.
  • If we want to change the space occupied by the Legend, select the Legend and drag the legend using the mouse as per the required size.

Final output

Things to Remember About Legends in Excel Chart

  • Legend is the space located on the plotted area of the chart in excel.
  • It has Legend keys that are connected to the data source.
  • Legend will appear automatically when we insert a chart in excel.
  • We can move the Legend to the top, bottom, right and left of the chart as per requirements by clicking on the “+” symbol and select the Legend option drop down and choose a required option from the drop-down.
  • Legend key names can be edited by clicking on the filter option and change the series name.
  • If we want to remove the Legend from the chart, we can remove it by disabling the legend option from the “+” sign or select the Legend and click on delete.

Recommended Articles

This has been a guide to Legend in Chart. Here we discuss how to add, remove and change the position of legends in an Excel chart, along with practical examples and a downloadable excel template. You can also go through our other suggested articles –

  1. Line Chart in Excel
  2. Excel Bar Chart
  3. Pie Chart in Excel
  4. Scatter Chart in Excel
Popular Course in this category
Excel Advanced Training (16 Courses, 23+ Projects)
  16 Online Courses |  23 Hands-on Projects |  140+ Hours |  Verifiable Certificate of Completion
4.8
Price

View Course

Related Courses

Excel Data Analysis Training (17 Courses, 8+ Projects)4.9
Excel for Marketing Training (8 Courses, 13+ Projects)4.8
0 Shares
Share
Tweet
Share
Primary Sidebar
Footer
About Us
  • Blog
  • Who is EDUCBA?
  • Sign Up
  • Live Classes
  • Corporate Training
  • Certificate from Top Institutions
  • Contact Us
  • Verifiable Certificate
  • Reviews
  • Terms and Conditions
  • Privacy Policy
  •  
Apps
  • iPhone & iPad
  • Android
Resources
  • Free Courses
  • Excel Charts
  • Excel Tips
  • All Tutorials
Certification Courses
  • All Courses
  • Excel VBA Course - All in One Bundle
  • VBA Course
  • Excel Data Analysis Course
  • Excel for Marketing Course
  • Excel for Finance Course
  • Excel for HR Training

ISO 10004:2018 & ISO 9001:2015 Certified

© 2022 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA
Free Excel Course

Excel functions, formulas, charts, formatting creating excel dashboard & others

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

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA Login

Forgot Password?

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA
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

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

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

By signing up, you agree to our Terms of Use and Privacy Policy.

Let’s Get Started

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

Download Legend Chart Excel Template

EDUCBA

Download Legend Chart Excel Template

EDUCBA

डाउनलोड Legend Chart Excel Template

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

Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more