Disclosure: This post may contain affiliate links, meaning when you click the links and make a purchase, we receive a commission.

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

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.


Download Practice Workbook


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


3 Easy Ways to Edit Legend of Pie Chart in Excel

In this section, you’ll find 3 easy ways for editing the legend of a Pie Chart in an Excel workbook both by updating data manually and by using Excel built-in features. Let’s check them now!


1. Edit Pie Chart Legend Manually by Updating Data

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: How to Make a Pie Chart with Multiple Data in Excel (2 Ways)


2. Modify Legend 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 Make Two Pie Charts with One Legend in Excel


Similar Readings


3. Edit 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 Edit Pie Chart in Excel (All Possible Modifications)


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

Rafi

Rafi

Hey there! I am Md. Rafiul Hasan. Currently I am working as an Excel & VBA content developer. I like new ideas and want to explore the field of innovation. Excel has saved our worktime and made it easy for us to quick calculations. I am trying to make it easier for you to overcome the obstacles you face while working on Excel. Stay connected!

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo