How to Show Percentage and Value in Excel Pie Chart

Get FREE Advanced Excel Exercises with Solutions!

Pie charts are regularly applied due to the fact they may be greater visually attractive and easy for all audiences to understand. Each part of the pie chart, which is divided into a couple of segments, represents a specific subcategory of the unique information set. As every subcategory shows the percentage of information, this subcategory information is every now and then displayed the use of the unique values and in different instances the use of percentages. In this article, we will show you how to display percentage and value in Excel Pie Chart.


How to Show Percentage and Value in Excel Pie Chart

A pie chart shows a dataset or the proportionate outcome of an analysis. Daily computations mainly utilize this Excel capability. To do so, we will apply the Format Data Labels option creating a pie chart first. Let’s say we have a sample data set to show Percentage and Value in Excel Pie Chart using step by step procedure. We will discuss the steps below.

Sample Data


Step 1: Selecting Data Set

  • Firstly, select all the columns from the given data set.

Sample Data


Step 2: Using Charts Group

  • Now, select the Insert tab.
  • Then, select the Insert Pie Chart command from the Charts group.

Sample Data

Read More: [Solved]: Excel Pie Chart Not Grouping Data


Step 3: Creating Pie Chart

  • Now click on the 2-D Pie Chart command, which is marked with a red color rectangle.

Step by Step Procedures to Show Percentage and Value in Excel Pie Chart

  • The above data set shows this pie chart.

Step by Step Procedures to Show Percentage and Value in Excel Pie Chart

Read More: How to Show Percentage in Legend in Excel Pie Chart


Step 4: Applying Format Data Labels

  • From the Chart Element option, click on the Data Labels.

Step by Step Procedures to Show Percentage and Value in Excel Pie Chart

  • These are the given results showing the data value in a pie chart.

Step by Step Procedures to Show Percentage and Value in Excel Pie Chart

  • Right-click on the pie chart.
  • Select the Format Data Labels command.

Step by Step Procedures to Show Percentage and Value in Excel Pie Chart

  • Now click on the Value and Percentage options.
  • Then click on the anyone of Label Positions. Here, we will click the Best Fit option.

Step by Step Procedures to Show Percentage and Value in Excel Pie Chart

  • This is the final pie chart in Excel which shows the percentage and value simultaneously.

Step by Step Procedures to Show Percentage and Value in Excel Pie Chart
Read More: How to Show Total in Excel Pie Chart


Download Practice Workbook


Conclusion

In this article, I’ve covered the step-by-step process of how to display Percentage and Value in a Pie Chart. I sincerely hope you enjoyed and learned a lot from this article. Additionally, if you want to read more articles on Excel, you may visit our website, Exceldemy. If you have any questions, comments, or recommendations, kindly leave them in the comment section below.


Related Articles


<< Go Back To Excel Pie Chart | Excel Charts | Learn 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.
Bishawajit Chakraborty
Bishawajit Chakraborty

Bishawajit Chakraborty, a Rajshahi University of Engineering & Technology graduate with a B.Sc. in Mechanical Engineering, has been associated with ExcelDemy since 2022. Presently, he is a content developer, specializing in Excel Power Query, Data Analysis and VBA. It is worth mentioning that he has authored more than 90 articles on VBA content development. His profound interest lies in the fields of data analytics and data science. He possesses expertise in VBA, Power BI, machine learning, and Python... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo