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

Excel Pie Chart Labels on Slices: Add, Show & Modify Factors

Excel Pie chart is a familiar figure to all of us. We use this type of chart to visualize the total amount in percentage. Like every type of chart, a pie chart can display data labels for the convenience of its users. These data labels can modify in several ways. In this article, we will show some suitable examples to show Excel pie chart labels on slices. If you are curious about it, download our practice workbook and follow us.


Download Practice Workbook

Download this practice workbook for practice while you are reading this article.


5 Examples with Excel Pie Chart Labels on Slices Considering All Factors

To demonstrate the examples, we consider a dataset of the production amount of the first eight months of an industry. The name of the months is in the range of cells B5:B12, and the number of products is in the range of cells C5:C12.


1. Showing Pie Chart Labels on Slices

We have to follow the following steps to insert the pie chart with data labels.

πŸ“Œ Steps:

  • First, select the range of cells B5:C12.
  • After that, in the Insert tab, click on the drop-down arrow of the Insert Pie or Doughnut Chart.
  • Then, choose the 3-D Pie option from the 3-D Pie section.

Showing Pie Chart Labels on Slices

  • The chart will appear in front of you.
  • Now, we will do all the tasks on the data labels. So, click on the Chart Element icon and only check the Data Labels option.
  • You will find the data labels on the pie chart.

  • Moreover, you can change the chart style from the Chart Design tab.
  • For that, in the Chart Design tab, choose your desired chart style. For our chart, we choose Style 7 from the Chart Style group.

Showing Pie Chart Labels on Slices

  • Our task is completed.

Showing Pie Chart Labels on Slices

Finally, we can say that our working method worked perfectly, and we are able to show Excel pie chart labels on slices.

Read More: How to Show Pie Chart Data Labels in Percentage in Excel


2. Modifying Pie Chart Labels

Now, we will demonstrate to you all the ways to modify the data labels font. We are going to show the changing procedure of font color, style, and size.


2.1 Changing Font Color

First, we will show you how to change the Font Color of the data labels. The steps of this task are given as follows:

πŸ“Œ Steps:

  • First of all, click on the data labels to select all of them.

  • Now, in the Home tab, click on the drop-down arrow of the Font Color from the Font group and choose your desired color.
  • For our chart, we choose Black, Text 1.

Modifying Excel Pie Chart Labels on Slices

  • You will see all the font colors of the data labels changed.

Modifying Excel Pie Chart Labels on Slices

  • Besides it, you can select the More Colors option to get your desired font color.

Thus, we can say that our procedure worked perfectly, and we are able to change the Excel pie chart labels color on slices.


2.2 Changing Font Style

In this step, we will show you the way to change the Font Style. The procedure for this task is given below:

πŸ“Œ Steps:

  • At first, click on the data labels to select all of them.
  • After that, in the Home tab, click on the drop-down arrow of the Font box from the Font group and choose your desired font style.
  • In our chart, we choose the Times New RomanΒ font.

Modifying Excel Pie Chart Labels on Slices

  • You will see all the font styles of all the data labels get the new font style.

Modifying Excel Pie Chart Labels on Slices

Finally, we can say that our procedure worked perfectly, and we are able to change the Excel pie chart labels style on slices.


2.3 Changing Font Size

In the following step, we are going to demonstrate to you the way to change the Font Size. The steps for this task are given below:

πŸ“Œ Steps:

  • At first, click on the data labels to select all of them.
  • Now, in the Home tab, click on the drop-down arrow of the Font Size from the Font group and choose your desired font size.
  • In our case, we choose the 11 font size.

Modifying Excel Pie Chart Labels on Slices

  • You will see the size of the font will increase.
  • Besides it, you can click on the Font Size box.
  • As a result, the font size gets selected.
  • Now, write down the font size using your keyboard.
  • Press Enter.
  • You will get the font size increased.

  • Moreover, you can use the Increase Font Size and Decrease Font Size commands to enlarge and reduce the font size. However, those commands will increase or decrease the font size one unit at a time.

In the end, we can say that our methods worked successfully, and we are able to change the Excel pie chart labels size on slices.

Read More: How to Format a Pie Chart in Excel


3. Adding Multiple Types of Data Labels

Now, we will demonstrate how to show different types of data in the data labels of the pie chart. We are going to add values, percentages, and category names to our pie chart.


3.1 Adding Value in Data Labels

In the first step, we will show how to add the Values to the data labels. The steps to add values to the data labels are given below:

πŸ“Œ Steps:

  • Adding value to data labels is quite an easy job. When you check the Data Labels option on the Chart Elements icon, it will automatically show the values.

  • However, if the values are not showing, then double-click on the data labels on the pie chart.
  • As a result, a side window called Format Data Labels will appear.
  • Now, go to the drop-down of the Label Options to Label Options tab.
  • Then, check the Value option.

Adding Multiple Types of Data Labels on Excel Pie Chart Slices

  • You will get the values in the data labels.

At last, we can say that our process worked precisely, and we are able to show values in the Excel pie chart labels on slices.


3.2 Inserting Percentage

Now, we will show how to add the Percentages to the data labels. The procedure to add percentages to the data labels is given below step-by-step:

πŸ“Œ Steps:

  • First of all, double-click on the data labels on the pie chart.
  • As a result, a side window called Format Data Labels will appear.
  • Then, go to the drop-down of the Label Options to Label Options tab.
  • After that, check the Percentages option and uncheck all other options.

Adding Multiple Types of Data Labels on Excel Pie Chart Slices

  • You will get the percentages in the data labels.

So, we can say that our method worked perfectly, and we are able to show percentages in the Excel pie chart labels on slices.


3.3 Adding Category Name

Here, we are going to show how to add the Category Name to the data labels. The method to add category names to the data labels is given below step-by-step:

πŸ“Œ Steps:

  • First, double-click on the data labels on the pie chart.
  • As a result, a side window called Format Data Labels will appear.
  • Now, go to the drop-down of the Label Options to Label Options tab.
  • Then, check the Category Name option.

Adding Multiple Types of Data Labels on Excel Pie Chart Slices

  • You will get the category names in the data labels.

Adding Multiple Types of Data Labels on Excel Pie Chart Slices

So, we can say that our method worked perfectly, and we are able to show category names in the Excel pie chart labels on slices.

Read More: How to Make a Multi-Level Pie Chart in Excel (with Easy Steps)


Similar Readings


4. Changing Background of Labels

We can also modify the background of the data labels and the shape outline of our pie chart. Now, we are going to demonstrate the process.


4.1 Modifying Label Fill

In this step, we will change the data label shape fill. The steps to modify the background fill of the data labels are given below.

πŸ“Œ Steps:

  • At first, double-click on the data labels.
  • As a result, a side window called Format Data Labels will appear.
  • After that, go to the drop-down of the Label Options to Fill & Lines tab.
  • Now, in the Fill section, you will see several options to modify the background fill.
  • Choose your desired one. In our case, we choose the Gradient fill.

Changing Background of Data Labels on Excel Pie Chart Slices

  • You will see the background fill of the data labels will change.

  • Moreover, you can change the fill background color from the Home and Format tabs.
  • For that, in the Home tab, click the drop-down arrow of the Fill Color option from the Font tab and choose your desired color. In our case, we choose the Orange, Accent 2, Lighter 60%.
  • The background will be changed.

Changing Background of Data Labels on Excel Pie Chart Slices

  • Besides it, you can change the background from the Format tab.
  • In the Format tab, click on the drop-down arrow of the Shape Fill option from the Shape Styles group.
  • Choose your desired color. In our chart, we choose the Orange, Accent 2, Lighter 60% color.
  • You will get the data labels with a different background color.

Changing Background of Data Labels on Excel Pie Chart Slices

Thus, we can say that our method worked perfectly, and we are able to modify the fill background in Excel pie chart labels on slices.


4.2 Changing Label Shape Outline

Besides changing the data label background fill, we can also change the data label shape outline. It will help us to separate the data labels from the pie chart.

πŸ“Œ Steps:

  • First of all, click on the data labels on the pie chart.
  • Now, in the Format tab, click on the drop-down arrow of the Shape Outline from the Shapes Style group.
  • Then, choose your desired color for the shape outline. We choose White, Background 1 color for our shape outline.

Changing Background of Data Labels on Excel Pie Chart Slices

  • You will see the shape outline color will change.

Changing Background of Data Labels on Excel Pie Chart Slices

Finally, we can say that our method worked successfully, and we are able to modify the shape outline in Excel pie chart labels on slices.


5. Removing Pie Chart Labels on Slices

In this step, we will show you how to remove data labels from the pie chart. The procedure is shown below step by step:

πŸ“Œ Steps:

  • First, select the chart and click on the Chart Elements icon.
  • Now, uncheck the Data Labels option.
  • You will see the data labels will disappear from the chart.

  • Moreover, you can remove the data labels using your keyboard.
  • For that, click the data labels and make sure all the data labels are selected.
  • After that, press the Delete key.
  • You will get the data labels removed.

Removing Pie Chart Labels on Slices

In the end, we can say that our procedure worked perfectly, and we are able to remove the data labels from the Excel pie chart on slices.


Conclusion

That’s the end of this article. I hope that this article will be helpful for you and you will be able to show excel pie chart labels on slices. Please share any further queries or recommendations with us in the comments section below if you have any further questions or recommendations.

Don’t forget to check our website ExcelDemy for several Excel-related problems and solutions. Keep learning new methods and keep growing!


Related Articles

Soumik Dutta

Soumik Dutta

Hi! I am Soumik. I have completed my Bachelor of Science in Naval Architecture and Marine Engineering. I have found my calling in Machine Learning and Data Science, and in pursuing so, I have realized the importance of Data Analysis. Excel is one excellent tool to fulfill the purpose. I am always trying to learn every day about different features of Excel and trying to share here what I am learning.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo