how to create pie chart in excel with percentages

They should get rid of them and save you a lot of manual deletion. Step 2: To determine the percentages divide each value. If you noticed that you’ve entered the same data multiple times after creating your pie chart (a common mistake) you can try some of the formulas in our how to find duplicates in Excel guide. How to Create a Pie Chart Step 1: Add all the values to get the total quantity mentioned in the table. We even have a dedicated bar graph in Excel guide to help you make one.Įxtra: How to Find Duplicates in Excel Data and Remove Them

If you realized that a pie chart doesn’t really work with your data set, chances are you can’t go wrong with a trusty bar graph.

The smallest sections of your pie will be automatically split into a bar chart.

The option is in 2-D pie settings, next to the pie in pie icon. Select your data, click the pie icon, and choose the Bar of Pie chart option.This is quite useful, as it lets viewers more easily see the differences between them: Alternatively, you can create a Bar of Pie chart, which as you may expect displays a small bar chart next to your data for the smallest.

How to create pie chart in excel with percentages