How To Add Legend In Excel Chart

Legends in excel chart Excel nautical chart legends depict description of significant elements and provides easy access to any chart. These legends are represented with the assistance of colours or symbols and distinguish information for better understanding. read more are basically representation of data itself, it is used to avoid whatever sorts of confusion when the data has the aforementioned 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-manus side of the given excel chart.

Add Legends to Excel Charts

Legends are a pocket-sized visual representation of the chart's data series to empathize each data serial without whatever sort of confusion. Legends are directly linked to the chart information range and change accordingly. In elementary terms, if the information includes many colored visuals, legends prove what each visual label means.

If you await at the higher up prototype 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 Northward zone, red color represents the E zone, green colour represents the South zone, and light blue represents the W zone.

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

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

Tabular array of contents

Add Legends to Excel Charts
- How to Add together Legends to Chart in Excel?
  - Example #one – Work with Default Legends in Excel Charts
  - Example #2 – Positioning of Legends in Excel Charts
  - Example #3 – Excel Legends are Dynamic in Nature
  - Example #four – Overlapping of Legends in Excel Chart
- Things to Remember While Adding Legends in Excel
- Recommended Articles

Yous are complimentary to utilize this epitome on your website, templates etc, Please provide united states with an attribution link Article Link to be Hyperlinked
For eg:
Source: Legends in Excel Chart (wallstreetmojo.com)

How to Add Legends to Chart in Excel?

Beneath are the few examples to add together legends in excel.

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

When you create a nautical chart in excel In Excel, a graph or nautical chart lets the states visualize information nosotros'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: one - Numerical Information, 2 - Data Headings, and 3 - Information in Proper Order. read more , we see legends at the bottom of the chart just below the X-Axis.

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

For case, look at the below image.

Hither 2014, 2015, 2016, 2017, and 2018 are the main categories. Under these categories, we take sub-categories that are common for all the years, i.east., North, Eastward, South, and West.

Example #2 – Positioning of Legends in Excel Charts

Equally we accept seen, by default, nosotros get legends at the bottom of every chart. But that is non the end of it; nosotros tin adapt it to the left, correct, top, peak correct, and bottom.

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

If you click on that PLUS icon, we will come across all the chart elements.

Hither we can modify, enable, and disable all the chart elements. Now get to Legend and place a cursor on the fable; we will run into Fable options.

Right at present, it is showing equally Lesser, i.e., legends are showing at the bottom of the nautical chart. You can alter the position of the legend as per your wish.

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

Legend at Right Side

Click on the Right option in Fable.

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

Legends at the acme of the chart

Select Summit pick from the Legend, and you volition meet the legends at the top of the chart.

Legends at the Left Side of the chart

Select the Left pick from the Legend, and you will come across the legends on the left side of the chart.

Legends at the Meridian Right Side of the Chart

Get to more options, select the Top Right pick, and you will encounter the result as follows.

Legends at the Top Right Side of the Chart

If you lot are using Excel 2007 & 2010, positioning of fable will not be bachelor, every bit shown in the to a higher place image. Select the chart and get to Design.

Under Design, we take the Add Nautical chart Element.

Click on the drop-down listing of Add together Chart Chemical element > Legends > Legend Options.

In the higher up tool, we demand to change the legend positioning.

Legends are dynamic in excel as formulas. Since the legends are directly related to the data series, any changes fabricated to the information range will bear on legends directly.

For instance, look at the chart and legends.

Now I will change the Due north zone's color to Red and see the impact on legends.

Legends' indication color has too changed to Ruddy automatically.

Now for experiment purposes, I will modify the N zone to India in the excel prison cell.

Now run into what the fable name is.

It is automatically updated the legend proper noun from N to INDIA. These legends are dynamic in nature if they are straight referred to equally the data series range.

Case #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.

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

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

Beneath are a few things to retrieve.

Past default, we become legends at the lesser.
Legends are dynamic and alter as per the change in color and text.
We can alter the positioning of the fable as per our wish but cannot identify outside the chart surface area.