Step-by-step instructions on how to make a regular pie chart in Excel
Here is a simple table aggregating EU28 population by four regions.
Select the entire table and choose the pie chart from the Insert menu.
Right-click the legend and select Delete from the popup menu.
Select all slices (1) and change fill color (2).
Select column [Population] from the table, click the down arrow and sort from largest to smallest.
Right-click the chart and choose Add Data Labels from the popup menu. Choose the best options for your chart. In the example below, I chose Category Name and Percentage and I added Show Leader Lines for the North slice.
Test Label Position and choose the best position. Don’t forget that you can select a single label (indicated by white and slightly bigger circles around the selected object) and move it around.
We want to emphasize that Western countries account for more than half of the EU28 total population. Choose a darker fill color for the West slice, write a title in a cell. Choose the current title, enter “=” and point to that cell.
Remove the border around the chart, adjust other details, and your chart is ready.
The example below is similar, but uses 28 slices instead of just four. It uses the table in sheet PopCountry.
Since the focus is on showing that four countries account for more than half of the population, there is no point in identifying the remaining countries
This one combines both approaches: it uses color to group countries by region and uses two sorting keys: total population by region, and then descending order of population inside each region.