As you know Excel has many options to make your data presentable. Visual presentation of your data depends on tables, charts, and graphs. Among different types of charts, Pie chat is one of the most used because of its easiness and appealing format for everyone.
How to add percentages to a Pie chart in Excel, do you have any idea?
Well, sometimes you need to add different additional options in a chart. A pie chart consists of various parts that represent a subcategory of the original dataset. The percentage is used in a chart when you need to present a sub-category that shows the proportion of data.
Pie charts are the most loved ones when you need to present data nicely.
Let’s see how you can add percentages to the pie chart.
How to Add Percentages to Pie Chart in Excel with Chart Styles?
In this method, you will learn a simple procedure that lets you add percentages to the pie chart. according to the given dataset, you need to show percentages for each of the ethnic groups consisting of the total population. Below are simple steps to follow:
- Activate the Pie chart by clicking on it. The Edit mode will enable.
- Select the Chart Design tab given on the Excel Ribbon.
- Click on the 3rd option from the Chart Styles options.
Now, you can witness the pie chart displaying the percentages for all of the constituent parts.
How to Show Percentages on a Pie Chart in Excel?
The percentage symbol % will display on the data labels by default when the source data appears in the pie chart. The percentage sign appears right after you activate the Data Labels option given under Chart Elements.
Organizing data labels is easier when the source data includes numbers as you can show original values or percentages, or both.
Right-click on a piece of the chart and choose Format Data Labels from the context menu.
From the Format Data Labels pane, choose the Value or Percentage box. Or else you can even choose both options. By default, you will see that Excel analyzes the percentages with the whole pie showing 100%.
How to Add Percentages to Pie Chart in Excel with Context Menu?
The context menu is useful when you need to add percentages to a Pie chart in Excel. For this, you can follow the steps given below:
- Right-click on the pie chart and the context menu will pop up.
- Click on the Add Data Labels.
- Right-click once again on the pie chart and the context menu will pop up.
- Now, choose the Format Data Labels option.
How to Add Percentages to Pie Chart in Excel with Quick Layout?
In this method, we will use the Quick Layout option. It gives effective and quick outcomes to present percentages in a pie chart. let’s follow the steps given below:
- Activate the Chart Design tab by clicking on the pie chart.
- Now, click on the Quick Layout option given in the Chart Design tab.
- Select the first layout that simply appears with the percentage data label.
- By following the above steps, you can see the percentage is added to the pie chart.
Other Layouts:
You will witness the Layout2 result as given below:
The outcome of Layout6 is given below:
Bonus Note: Note that if the Value option is selected with the Percentage option, you will notice the pie chart with the original value for each element present in the dataset.
To Wrap Up:
Now, you are familiar enough to how to add percentages to pie charts in Excel by using 3 different methods. Each method mentioned above is entirely useful and effective. Therefore, you can practice each method without any fear.
