How to Rename Legend in Excel (2 Useful Methods)

Get FREE Advanced Excel Exercises with Solutions!

If you are looking for how to rename legend in Excel, then you are in the right place. While using Excel, we often need to use charts of various types, where the charts are presented clearly if we use legends. Sometimes, we also need to change legend names. In this article, we’ll try to discuss how to rename legend in Excel.


What Is Legend in Excel?

In essence, legends are basically data representations. The majority of the time, when data contains uniform values across all categories, legends are used. They aid in our understanding of the data.

Read More: What Is a Chart Legend in Excel?


How to Rename Legend in Excel: 2 Ways

Excel offers a couple of ways to rename legends. To show this, we have made a dataset which has column headers as Name of Company, Profit in January (M), Cost in January (M). The dataset is like this. 

how to rename legend in excel


1. Renaming Legend in Excel Dataset

We can rename legends by working in the dataset, more specifically, in the column headers which are used as legends in the chart. Suppose, we have the following dataset and chart where Profit in January (M) and Cost in January (M) are legends. We need to rename these legends.

Renaming Legend in Excel Dataset

  • Firstly, double-click the C4 cell and change the column header to Net Profit (M).
  • Secondly, press ENTER.
  • Eventually, we’ll see that the first legend of the chart is changed to Net Profit (M).

how to rename legend in excel

  • To change the other legend, similarly, double-click the D4 cell.
  • Secondly, change the column header to Net Cost (M).
  • Thirdly, press ENTER.
  • Consequently, we’ll see that the other legend in the chart is also changed to Net Cost (M).

Read More: How to Edit Legend in Excel


2. Using Select Data Source

We can also rename legend by using Select Data Source. When the legend needs to be distinct from the title, using Select Data Source to edit the legend is helpful. Usually, when we update the title, the legend follows suit. However, there are situations where the title can remain the same. There, this approach is appropriate.
In the following figure, we need to rename the legend Profit in January (M)

Using Select Data Source

  • Firstly, click on the chart.
  • Secondly, go to Chart Design > choose Select Data.

how to rename legend in excel

  • Eventually, a Select Data Source window will appear.
  • Thirdly, select Profit in January (M) > click Edit.

  • An Edit Series window will appear.
  • Fourthly, give a new name in the Series name box. In this case, it is Net Profit.
  • Fifthly, click OK.

  • Finally, again click OK in the Select Data Source window.

how to rename legend in excel

  • Consequently, the first legend of the chart will change to Net Profit.

how to rename legend in excel

Read More: How to Create a Legend in Excel Without a Chart


How to Format Legend in Excel

We can format legend in the chart very easily. Suppose, in the following figure, We have two legends as Profit in January (M) and Cost in January (M). We need to change the position of these legends.

How to Format Legend in Excel

  • Firstly, right-click on the legend > select Format Legend.

how to rename legend in excel

  • Eventually, a Format Legend window will appear.
  • Secondly, in the Legend Position box choose any of the options according to your requirements. In this case, it is Top.

  • Consequently, we’ll see that the position of the legend is now on the top of the chart.

how to rename legend in excel

Read More: How to Change Legend Colors in Excel


How to Change Legend Name in Excel Pivot Chart

If we use the Pivot Chart in Excel, we can also change the legend of that Pivot Chart easily.
Suppose, we have the following dataset. Where Name of Company, Profit (M), Fixed Cost (M) and Variable Cost (M) are column headers. Let’s follow the instructions below to change the legend title or name!

How to Change Legend Name in Excel Pivot Chart

We have made a Pivot Chart based on this dataset like this. Here, the legend is Value.
We need to change the legend here. Basically, we’ll try to add another legend here to make a change.

how to rename legend in excel

  • Firstly, click on the chart.
  • Secondly, go to PivotChart Analyze > choose Field List.

  • Eventually, a PivotChart Fields window will appear where we can see Values in the Legend box.

We want to add the Name of Company as a legend.

  • To do this, drag the Name of Company from the Filters box and place it in the Legend (Series) box.

  • Consequently, Name of Company will be added to the chart as a legend and thus the change happens.

how to rename legend in excel

Read More: How to Reorder Legend Without Changing Chart in Excel


Things to Remember

  • If we change anything in the title which is not connected with the chart, we will see legend as unchanged. Because editing legend in Excel data must require connection between the cell which we have selected and the chart.
  • Editing legend by using Select Data source is handy to use when we use various types of big data base and need to change them according to different conditions and requirements.

Download Practice Workbook


Conclusion

That’s all about today’s session. And these are the ways to rename legend in Excel. We strongly believe this article would be highly beneficial for you. Don’t forget to share your thoughts and queries in the comments section.


Related Articles


<< Go Back To Legend in Excel Chart | Excel Chart Elements | Excel Charts | Learn Excel

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Shajratul Alam Towhid
Shajratul Alam Towhid

Md Shajratul Alam Towhid, a BSc graduate in Naval Architecture & Engineering from Bangladesh University of Engineering and Technology, holds a pivotal role as an Excel & VBA Content Developer at ExcelDemy. Fueled by a deep passion for research and innovation, he actively engages with Excel. In his capacity, Towhid not only adeptly tackles complex challenges but also exhibits enthusiasm and expertise in gracefully navigating tough situations, emphasizing his unwavering commitment to consistently delivering exceptional, high-quality content that... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo