Pie Chart Example : Excel Chart Formatting Tips

What is a pie chart?

A pie chart is a circular statistical graphic divided into slices to illustrate proportions of a whole.  In a pie chart, the arc length of each slice represents the data values. There are different types of pie charts available that are helpful in displaying details of different types of data.

You can review this data using the various pie chart types below if you would like to see the top five beauty products in the world.

Rank  Beauty Products WorldwideNumber of Countries
1-MAC Lipstick Velvet Teddy46
2-Benefit They’re Real Lengthening Mascara21
3-Anastasia Beverly Hills Dipbrow Pomade20
4-Laura Mercier Translucent Loose Setting Powder9
5-MAC Lip Pencil Cork8
pie chart

Why do we use a pie chart?

Because pie charts are effective for the following reasons:

It clearly shows proportions at a glance. Large and small portions can be easily compared with this type of chart. It also makes it easy to examine differences in data values.

Their simplicity in representing data makes pie charts ideal for audiences who are not as familiar with complex data visualizations.

RankCountryMarket share
1 Netherlands50.70%
2 Italy5.70%
3 Ecuador4.40%
4 Germany4.20%
5 Canada3.10%
6Others31.90%
how to make pie chart in excel with percentages

To create an effective and accurate pie chart, avoid the following:

The number of slices plays an important role in making a pie chart effective. Too many slices make the chart difficult to understand because it becomes difficult to distinguish between many small pieces. Therefore, it is recommended that the number of slices should not exceed 6.

Rank LIPSTICK SHADEGLOBAL ANNUAL SEARCHES
1Velvet Teddy266400
2Mehr177600
3Twig145200
4Whirl145200
5Taupe118800
6Diva97200
7Chili97200
8Honey love97200
9Kinda Sexy79200
10Yash79200
11Faux79200
12Please Me52800
13Russian Red52800
14Modesty43200
15Cosmo43200
examples of bad pie charts

 Slices of the same size can be confusing to the audience. When slices appear to be roughly the same size, it becomes difficult to make accurate visual comparisons. For data where most of the values ​​look roughly the same, other charts, such as bar charts and pie charts, are more effective.

Below is an example data for top beauty product. 

Serial Top 05 Beauty Products sale in a minuteUnit
1-MAC Lipstick Velvet Teddy40
2-Benefit They’re Real Lengthening Mascara45
3-Anastasia Beverly Hills Dipbrow Pomade46
4-Laura Mercier Translucent Loose Setting Powder47
5-MAC Lip Pencil Cork48
why pie charts are bad

Using too many 3D effects, shadows, or titles can make it difficult for viewers to understand the slices and make accurate comparisons, so it’s best to use a simple 2D pie chart.

RankCountryMarket share
1 China54.80%
2 Vietnam13.40%
3 Indonesia3.70%
4 Netherlands3.10%
5 Poland2.10%
6Others22.90%
how to make a 3d pie chart in excel with multiple data

When choosing a pie chart for your data, you need to make sure that the categories logically contribute to the overall picture. If the data doesn’t add up to a meaningful total, it’s better to choose another type of chart, such as a bar chart.

Similarly, follow the same protocol for percentage summation. The data ratio should be 100%.

RankCountaryMarket share
1 Indonesia20.40%
2 Malaysia13.70%
3 Netherlands4.90%
4 Spain4.40%
5 Canada3.70%
pie chart in excel not working

It is not a good idea to use pie charts to show trends over time because pie charts are static and show proportions at a single point in time. Line charts or bar charts are better for seeing trends than pie charts.

Using too much text and labels directly on the chart can make it difficult for viewers to understand the slices.

Rank The most popular fragrance around the worldNumber of Countries
1Good Girl42
2Black Orchid21
3Daisy17
4Daisy Eau So Fresh10
5Opium7
6Si5
7Femme4
8I Love Love4
9Modern Princes3
10Decadence2
pie chart advantages and disadvantages

What are the drawbacks of pie charts?

Despite their simplicity and effectiveness, pie charts also have some drawbacks and several limitations.

Researchers say that it is difficult for the human eye to compare areas or angles of different slices when there is little difference in data values. In this sense, caution is needed when using pie charts.

Pie charts are not as good at showing exact values ​​as others. In fact, pie charts primarily show ratios rather than exact numerical values. Labels can be used to show numerical values.

Not suitable for many categories because it is visually unappealing and one cannot extract the desired information from it.

The conflict of providing accurate details can be misleading. The use of exaggerated 3D effects or tilt can intentionally or unintentionally distort the perception of data.

Pie to pie,, You can take some values ​​from the first pie and add them to the second pie to make smaller percentages more readable or to highlight the values ​​in the second pie.

Bar of pie… can be used to show the proportion of a whole. Also, you can take some values from the first pie and combine them in a stacked bar to make small percentages more readable or highlight the values in the stacked bar.

3-D pie can be used to show the proportion of a whole or when numbers are 100%. Make sure the chart contains few slices.

excel chart tutorial

Doughnut : Use this type of chart when you want to show a percentage of a whole. It’s better to use it instead of a pie chart when there are multiple series that relate to a large amount.

RankCountryMarket share
1 China17.30%
2 United States7.40%
3 South Korea6.80%
4 Germany6.70%
5 Japan4.60%
excel chart formatting tips

In Microsoft Excel, you get the quick layout option. This option can change the layout of the chart.

In Layout 1 you can show the chart title, value, and percentage data labels.

In Layout 2 you can show the chart title, legend (top), and percentage data labels (best fit).

In Layout 3 you can show the legend (bottom)

In Layout 4 you can show category and value data labels (best fit).

In Layout 5 you can show chart titles and category data labels (best fit).

In Layout 6 you can show the chart title, legend (right), and percentage data labels (best fit).

In Layout 7 you can show the legend (right).

Market share of Meat and edible meat offal. All data refer to the year 2022.

RankCountryMarket share
1 Brazil14.60%
2 United States14.30%
3 Australia7.30%
4 Netherlands7.00%
5 Spain6.10%
pie chart example

The best thing about these layouts is that you can make any kind of modifications according to your needs.

To customize the color and style, you get the option of ‘Chart Quick Colors,’ which gives you colorful and monochromatic palettes.

Moreover, you get ‘Quick Styles,’ in which you get a lot of styles for your chart. You can use these quick styles to change the overall visual style of the chart. 

In short, there are so many options for chart styles that we need multiple articles that are enough to cover them all.

Remember, a pie chart is designed to show parts of a whole and illustrate relationships between different variables.

Finally, since a pie chart is an excellent and effective tool for representing overall proportions, some important precautions need to be kept in mind, and common and mentioned pitfalls should be avoided to make it effective.

Leave a Comment

Your email address will not be published. Required fields are marked *

Scroll to Top