Tag Archives: visually display percentages in Excel

How to create a pie chart in which each slice has a different radius in Excel

piechart_18

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. 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. Also, it can be a visually nice addition to any dashboard, report or presentation. For all these reasons, I have decided to create this pie chart in Excel and share it with you. continue reading >>

How to show percentages on three different charts in Excel

how-to-show-percentages-in-excel

Percentage is one of the most common ways of expressing a proportion. In Excel, you can use three different charts, namely a pie chart, a doughnut chart and a bar chart to show percentages of a whole. continue reading >>