How to Edit Legend of a Pie Chart in Excel (3 Easy Methods)

Get FREE Advanced Excel Exercises with Solutions!

You may have created a Pie Chart in Excel on the basis of some gathered data. But sometimes you may need to edit the legend of the Pie Chart you have created in Excel. In this article, I will show you how to edit the legend of a Pie Chart in an Excel Spreadsheet.


About Pie Chart Legend

Legend is a representation of entries that are linked to the data being graphically displayed in the plot area of a chart. Most charts in Excel use some kind of legends to help the reader understand the data that are plotted on a graph. When a pie chart is created in an Excel worksheet, legends are automatically created for the chart. Legend entries can be updated or edited when chart data is updated.

The marked entries here are legends for the plotted data.


1. Editing Pie Chart Legend Manually by Updating Data in Excel

Let’s say, we have got a dataset of sales of the salesmen of a shop over a certain period of time.

We have made a chart describing the sales of the shop over the mentioned time period.

Editing Legends of a Pie Chart

The marked texts here are the legends for the plotted data. To edit the legend by using this method, just follow the steps below:

  • At first, click the cell in the worksheet that you want to edit the legend.

Editing Legends of a Pie Chart

  • Next, type a new text in the cell and press ENTER. The legend in the chart will be changed.

Editing legend of a Pie Chart

  • Then, repeat the same for each cell and you will get the legend changed.

Edit Legend of a Pie Chart in Excel

So easy, isn’t it? These are the steps you can follow for Editing the legends by updating the data in the cell manually.

However, you can also change the orientation of the legend entries just by clicking the ‘+’ sign at the right corner> click Legend> select orientation (i.e. Right/Top/Left/Bottom, etc)

Editing the Legend of a Pie Chart

Read More: Add Labels with Lines in an Excel Pie Chart


2. Modifying Legend in Pie Chart Without Changing Data

Let’s say, for the dataset below, we want to change the legend of a Pie Chart in Excel without changing the data.

dataset for Editing Legends of a Pie Chart
To change the legend using this method, follow the steps below:

  • Firstly, click the chart area. Go to the Chart Design tab>click Select Data.

Edit the pie chart legend

  • Then, click Edit on the Horizontal (Category) Axis Labels.

Edit the pie chart legend

  • Next, assign a new Axis label range just by typing the legends you want to be separated with commas. Here, I’ve typed the initial letter (letters) of the name of the salesman.

Edit Legend of a Pie Chart in Excel

  • So, the dialogue box will show your newly typed legends. Click OK.

  • Finally, you will get your legends changed.

That’s how we can change the legends of an Excel Pie Chart without changing the value of the source data.

Read More: How to Edit Pie Chart in Excel


3. Editing Legends in a Pie Chart by Changing Source

For our previous dataset, we have created a 3-D Pie Chart.

We will now learn to change the legend in a Pie Chart by changing the source itself. And for this, follow the steps below:

  • First, click the chart area. Go to the Chart Design tab>click Select Data.

  • Now, the Select Data Source dialogue box will show up. Click Edit on the Horizontal Axis Labels as we want to change it.

  • Then, assign the Axis label range and click OK.

  • Afterward, click OK on the dialogue box.

  • Now your output will be ready with the legend changed.

That is how we can simply edit the legend of a Pie Chart by changing the source itself.

Read More: How to Change Pie Chart Colors in Excel


Download Practice Workbook


Conclusion

In this article, we have learned how to edit the legend of a Pie Chart both manually and by using the Excel feature. I hope from now on, you can quickly change the legend of a Pie Chart in an Excel worksheet. If you have any queries regarding this article, please don’t forget to leave a comment below. You can also visit our site ExcelDemy. Have a great day!


Related Articles


<< Go Back To Edit Pie Chart in ExcelExcel Pie ChartExcel ChartsLearn 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.
Rafiul Hasan
Rafiul Hasan

Rafiul Hasan, holding a BSc in Naval Architecture and Marine Engineering from Bangladesh University of Engineering & Technology, contributes significantly to the ExcelDemy project with almost 1.6 years of dedicated work. Currently an Excel and VBA Content Developer, he has a passion for problem-solving. Authoring over 100 articles for ExcelDemy showcases expertise in Microsoft Office Suites and Data Analysis. In addition to content development, Rafiul actively engages with the ExcelDemy forum, offering valuable solutions to user queries and... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo