How to Make a Pie Chart in Excel with Percentages

In this tutorial, we will learn how to create a pie chart in Excel that shows the percentage proportion of each country next to its count of gold medals. For this purpose, I'm using data from the top 10 gold medal winning countries at the Rio 2016 Olympics.

To start creating your pie chart, you need to enter the data you want to use. The basic idea is to create a separate pie chart for each category and make sure only the slice representing that category is visible. Then, set the area of each chart equal to the percentage value of its visible category and combine all charts together to create one single pie chart.

Here's how you can do it:

Alternatively, if you prefer written instructions, I can guide you through the process step by step. Just let me know!

Watch this video to see how to create a pie chart in Excel where each slice has a different radius based on the percentage it represents.

Creating a pie chart with varying radii is an excellent way to visually emphasize the relative importance of each category and draw attention to those with large percentages. This type of pie chart can be particularly useful when you want to highlight categories that make up a significant portion of the total.

In infographics and other visuals, I've often seen pie charts where each slice has a different radius based on its percentage value. The slices representing larger percentages have more substantial radii, while those with smaller percentages have shorter radii. This visual representation effectively communicates information about the relative importance of each category.

With these steps, you should now be able to create your own pie chart in Excel with varying radii based on the percentage it represents.

How to make a pie chart in excel with percentages