How Do I Add A Legend In Excel Without Charts

Legends in excel chart Excel chart legends depict clarification of significant elements and provides easy access to whatever chart. These legends are represented with the assistance of colours or symbols and distinguish information for ameliorate understanding. read more than are a representation of data itself. Information technology is used to avoid confusion when the data has the aforementioned values in all the categories. In add-on, information technology is used to differentiate the classes, which helps the user or viewer to understand the data more than properly. It is located on the right-paw side of the given Excel chart.

Add Legends to Excel Charts

Legends are a pocket-size visual representation of the nautical chart's data serial to understand each without defoliation. Legends are directly linked to the nautical chart information range and change accordingly. In simple terms, if the data includes many colored visuals, legends show what each visual label means.

If y'all look at the beneath image of the graph, the graph represents each year's region-wise sales summary. So in a year, nosotros take four zones: each year, the carmine color represents the N zone, the orange color represents the East zone, the dark-green color represents the South zone, and low-cal bluish represents the West zone.

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

Regarding legends, we comprehend all the things you need to know about the excel chart legends; follow this article to know the ins and outs of legends.

Tabular array of contents

Add Legends to Excel Charts
- How to Add Legends to Chart in Excel?
  - Instance #1 – Work with Default Legends in Excel Charts
  - Instance #two – Positioning of Legends in Excel Charts
  - Example #three – Excel Legends are Dynamic in Nature
  - Instance #4 – Overlapping of Legends in Excel Nautical chart
- Things to Retrieve While Calculation Legends in Excel
- Recommended Articles

You lot are gratis to use this image on your website, templates, etc, Please provide united states of america with an attribution link Article Link to be Hyperlinked
For eg:
Source: Legends in Excel Chart (wallstreetmojo.com)

How to Add Legends to a Chart in Excel?

Below are a few examples of adding legends in Excel.

You tin 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 chart lets us visualize information we've gathered from our data. It allows the states to visualize data in easy-to-understand pictorial ways. The following components are required to create charts or graphs in Excel: 1 - Numerical Information, 2 - Data Headings, and 3 - Information in Proper Order. read more , we see legends at the bottom of the chart below the X-axis.

The above nautical chart is a unmarried fable, i.e., in each category, nosotros accept merely one set of data, then there is no need for legends here. But, in the case of multiple items in each category, nosotros take to display legends to sympathise the scheme of things.

For example, look at the beneath prototype.

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, S, and West.

Example #2 – Positioning of Legends in Excel Charts

As nosotros have seen, by default, we go legends at the bottom of every chart. But that is not the finish; we can arrange it to the left, right, summit, right, and lesser.

For irresolute the positioning of the legends in Excel 2013 and later versions, at that place is a small PLUS push on the right-paw side of the nautical chart.

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

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

Information technology is showing equally Lesser, i.e., legends are showing at the bottom of the nautical chart. You tin can change the position of the legend as per your wish.

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

Legend at Correct Side

Click on the "Right" option in "Legend."

Nosotros will run across the legends on the right-hand side of the graph.

Legends at the top of the chart

Select the "Top" option from the "Legend," and we may see the legends at the nautical chart's top.

Legends at the Left Side of the chart

Select the "Left" pick from the "Legend,' and nosotros may see the legends on the left side of the chart.

Legends at the Top Right Side of the Chart

Go to "More Options," select the "Pinnacle Right" choice, and encounter the following result.

If you are using Excel 2007 and 2010, the positioning of the fable will non be available, every bit shown in the above prototype. Instead, select the chart and get to "Design."

UnderDesign,nosotros have the Add Nautical chart Element.

Click on the drop-down list of Add Nautical chart Chemical element > Legends > Legend Options.

In the above tool, nosotros demand to modify the legend positioning.

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

For case, look at the chart and legends.

We will change the "Northward" zone's colour to "red" and run into the bear upon on legends.

Legends' indication color has as well changed to cherry-red color automatically.

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

At present see what the legend name is.

It automatically updated the legend proper name from N to India. These legends are dynamic if straight referred to as the data series range.

Instance #4 – Overlapping of Legends in Excel Nautical chart

By default, legends volition not overlap other nautical chart elements, but if space is too constrained, they volition overlap on other nautical chart elements. Below is an instance of the aforementioned.

In the to a higher place image, legends are overlapped on the X-centrality. To make it proper, go to legends and check the option "Evidence the legend without overlapping the chart."

Information technology volition separate the legends from other chart elements and show them differently.

Beneath are a few things to recollect.

By default, we get legends at the bottom.
Legends are dynamic and alter as per the change in color and text.
We can change the positioning of the fable as per our wish only cannot place it exterior the nautical chart area.