Calculate the percentage proportion of each country next to its count of gold medals. For the purpose of this tutorial, I am using the data of top 10 gold medal winning countries of the Rio 2016 Olympics.Ģ. Enter the data that you will use to create the pie chart. The basic idea in creating this chart is to make a separate pie chart for each category in which only the slice representing that category is visible, set the area of each chart equal to the percentage value of its visible category and then combine all charts together to create one single pie chart. If you prefer written instructions, then continue reading.
Watch the video below to see how to create a pie chart in Excel in which each slice has a different radius based on the percentage it represents. In other Excel versions, there may be some slight differences in the described steps.
For all these reasons, I have decided to create this pie chart in Excel and share it with you. Also, it can be a visually nice addition to any dashboard, report or presentation. The advantage of such a pie chart is that it further emphasizes the relative importance of a particular category to the total and is useful when you want to draw attention to categories with large percentages. In infographics and other visuals, I have many times come across a pie chart in which each slice has a different radius based on the percentage it represents: the slices representing categories with large percentages have larger radii (the plural of radius is radii), while the slices representing categories with small percentages have shorter radii.
0 kommentar(er)
