WPS Office

Free All-in-One Office Suite with PDF Editor

correct-icon

Edit Word, Excel, and PPT for FREE.

correct-icon

Read, edit, and convert PDFs with the powerful PDF toolkit.

correct-icon

Microsoft-like interface, easy to use.

Free download

Windows • MacOS • Linux • iOS • Android

banner

How to change legend name in excel pie chart

July 22, 2022
7.3K Views

The legend is a form of graphical representation in which the names of the variables are placed on an axis of the histogram. Each line represents the measurement for a single category, and each vertical bar correspond to one score from that category. The legend helps you see how your categories have been distributed.

Changing legend names in excel is no rocket science, but one that could have devastating consequences if done incorrectly. If you change the name of your data series, not only will you lose formatting, but your chart will also be unable to read the data in it. Even if you're working with just one chart, this can be a problem.

In this article, we are going to see how to change legend name in excel.

How to show the legend name in the chart

 To change legend name in excel you have to have a data range where the legend is placed. If there is no need to make sure that the legend will be visible then it can be hidden or displayed as requested by the user. Following are some of the steps that can be followed to show legend name in excel:

  1. Select the chart and click on Chart elements by the top right corner of the chart.

  1. Now make sure the Legend box is checked.

How to change the legend name in the excel data

If you are creating a chart or graph in excel, then you might need to change the legend name in excel. This will help you to identify each shape in the chart easily and more clearly. Following are the steps that could be used to change legend name in excel easily.

This method works best with versions 2016/2016/mac/online

  1. To edit the legend name, select the cell that contains the legend name you want to change.

  1. Type the new legend name in the selected cell, and press Enter.

  1. The legend name in the chart updates to the new legend name in your data.

 

How to change legend name in excel using select data

Another way of changing legend name in excel is by using select data. Select data is used to make quick changes in excel and use so that you can quickly change the variable labels for your chart and get the desired output.

  1. Select the chart and select Chart Filters.

  1. After that, click on the Select Data option from the lower right corner of the menu.

  1. Next, select the chart series you want to change the name of.

  1. After you select the series, hit the edit button.

  1. Now, rename the series in the series name section and press OK.

  1. Finally select OK option the original select data dialogue box.

  1. Once you press OK, name of the series will be changed.

Did you learn about how to change legend name in excel? You can follow WPS Academy to learn more features of Word Document, Excel Spreadsheets and PowerPoint Slides.

You can also download WPS Office to edit the word documents, excel, PowerPoint for free of cost. Download now! And get an easy and enjoyable working experience.

 

15 years of office industry experience, tech lover and copywriter. Follow me for product reviews, comparisons, and recommendations for new apps and software.