EDUCBA Logo

EDUCBA

MENUMENU
  • Explore
    • EDUCBA Pro
    • PRO Bundles
    • Featured Skills
    • New & Trending
    • Fresh Entries
    • Finance
    • Data Science
    • Programming and Dev
    • Excel
    • Marketing
    • HR
    • PDP
    • VFX and Design
    • Project Management
    • Exam Prep
    • All Courses
  • Blog
  • Enterprise
  • Free Courses
  • Log in
  • Sign Up
Home Excel Excel Resources Excel Charts Pie Chart Examples
 

Pie Chart Examples

Steffi Madari
Article bySteffi Madari
Madhuri Thakur
Reviewed byMadhuri Thakur

Updated July 12, 2023

Pie Chart Examples

 

 

Pie Chart Examples (Table of Contents)

Watch our Demo Courses and Videos

Valuation, Hadoop, Excel, Mobile Apps, Web Development & many more.

  1. 2-D Pie Chart
  2. Pie of Pie Chart
  3. Bar of Pie Chart
  4. 3-D Pie Chart
  5. Doughnut Pie Chart
  6. Advanced Formatting

Definition of Pie Chart

Pie charts in Excel represent data in circular form by categorizing it into divisions or slices. Each slice represents a specific category or data point and highlights its contribution to the total value (usually 100%).

Pie charts are useful for effectively categorizing data and comparing its proportions. Pie charts examples are 2-D, Pie of Pie, Bar of Pie, 3-D, and Doughnut. These Pie Chart Examples teach you how to create different Excel pie charts and customize their appearance.

How to Make a Pie Chart in Excel?

To create a pie chart in Excel, follow the below steps:
Step 1: Select the data
Step 2: On the “Insert” tab, click on the pie symbol under the “Charts” group.
Step 3: Select the desired pie chart.
The pie chart is ready.
Excel has several pie chart examples, including 2-D, Pie on Pie, Bar of Pie, 3-D, and Doughnut.

Examples of Types of Pie Charts

You can download this Pie Chart Examples Excel Template here – Pie Chart Examples Excel Template

Example #1: 2-D Chart

Consider the following data on employee salary usage. We will create different types of pie charts for the below data. Let’s first learn how to create a 2D pie chart.
Example 1

Solution:

  • Select the data A1:B6
  • Go to the “Insert” tab, click on the drop-down arrow of the pie chart symbol, and select the first diagram, as shown below.

Example 1 Solution

After selecting the option, Excel will display the pie chart below.Example 1 Solution(2)

We can see that the above pie chart has divided each allocation category into different divisions and colors. Also, colors representing the division or allocation are shown at the bottom of the chart. It is known as the legend. Excel has also titled “Expenses ($) to the chart.

Now, let us learn how to customize the pie chart to enhance its readability.

1. Adding labels to the pie chart:
  • Right-click on the pie chart, choose “Add Data Labels,” and select “Add Data Labels” under the drop-down option, as shown below.

Example 1 Solution 1-1

Labels are inserted into the chart.
Example 1 Solution 1-2

The below image illustrates the chart elements.
Example 1 Solution 1-3

2. Displaying the contribution of a particular category in the data:
  • Click “Add Data Callouts” under the “Add Data Labels” option to display subcategories and percentages.

Example 1 Solution 2

The pie chart displays the allocation category and the percentage share of the corresponding categories. See the below image.
Example 1 Solution 2-1

Note: The total percentage of the pie chart is 100%.
3. Removing the chart title and legends from the chart:
  • Select the chart and click on the “+ “symbol in the upper-right corner, as shown below,

Example 1 Solution 3

The above image shows all the chart elements are marked ticked.

  • Deselect chart title and legend.

In the below image, only data labels are present.
Example 1 Solution 3-1

4. Adding the category name and percentage inside the division section:
  • Right-click on the pie chart and select “Format Data Labels”.

Example 1 Solution 4

The Format Data Labels menu will open on the right side.

  • Select or tick on the “Category Name“, “Percentage“, and “Show Leader Lines“.

Example 1 Solution 4-1

The category name and percentage are added inside the division section, as shown below.
Example 1 Solution 4-2

Advanced formatting of this pie chart is given below in the Advanced Formatting – 2-D Pie Chart section.

Example #2: Pie of Pie Chart

In this example, we will learn to create a pie of pie chart using the same data that we used for example 1.

The Pie of Pie chart highlights a small proportion of the whole data. It enhances the readability of the data.

  • Select the data.
  • Go to the “Insert” tab, and click on the pie symbol under the “Charts” group.
  • Select the 2nd option of 2-D Pie, as shown below.

Example 2

A pie to Pie chart will appear, as shown below.
Example 2-2

  • Right-click on the pie chart and select “Format Data Labels“.
  • Select “Category Name” and “Percentage” under the Label options.

Example 2-3

The pie of pie chart will look like this,
Example 2-4

Advanced formatting of this pie chart is given below in the Advanced Formatting – Pie of Pie Chart section.

Example #3: Bar of Pie Chart

The Bar of a Pie chart is useful to highlight a small percentage of the data in stacked bars. Let’s learn how to create a Bar of Pie chart.

  • Select the data and click on the 3rd option of the 2-D pie chart, as shown below.

Example 3

The Bar of the Pie chart will appear, as shown in the below image.
Example 3-2

Repeat the procedure of previous examples for adding percentages and categories.
Example 3-3

Advanced formatting of this pie chart is given below in the Advanced Formatting – Bar of Pie Chart section.

Example #4: 3-D Pie Chart

To create a 3-D Pie chart,

  • Select the data and click on the 3-D option, as shown below.

Example 4

A 3-D pie chart will appear. See the below image.
Example 4-1

Example 4-2

Advanced formatting of this pie chart is given below in Advanced Formatting – 3-D Pie Chart section.

Example #5: Doughnut Chart

A doughnut chart is useful when multiple series are related to a larger sum.

For creating the Doughnut pie chart,

  • Select the data and click on the Doughnut option, as shown below.

Example 5

A doughnut chart representing our data is shown below.
Example 5-2

Now, add the percentage to the pie chart.
Example 5-3

Advanced formatting of this pie chart is given below in the Advanced Formatting – Doughnut Pie section.

Advanced Formatting

Advanced Formatting: 2-D Pie Chart

Please note that this section considers the final result of all the above pie charts.

1. How do you Separate Slices in a Pie Chart?
Here, we will separate the grey slice or transport category.

  • Select the grey slice and drag it away from the pie chart with the mouse. See the below image.

Advanced Formatting - 2-D Pie Chart 1

The slice or transport category is separated from the pie chart.
Advanced Formatting - 2-D Pie Chart 1-2

We can again move the slice to its position in the pie chart.

2. How to Change the Format and Color of the Pie Chart?

  • Click on the pie chart.
  • A “Chart Design” will open next to the “Help” tab
  • Select any design from the Chart Design. We have selected Style 8.

Advanced Formatting - 2-D Pie Chart 2

The pie chart will appear in the following design format.
Advanced Formatting - 2-D Pie Chart 2-2

We can also change the format from the below option.
Advanced Formatting - 2-D Pie Chart 2-3

3. How do you Change Pie Chart Colors in Excel?

Click on the pie chart.

A Format Data Series menu will open up on the right side.

  • Select the “Color” option under the “Fill & Line” (green border in the below image) tab, as shown below.

Advanced Formatting - 2-D Pie Chart 3

The theme colors menu will open up. We can select colors from here or go to “More Colors” and select the desired colors.
Advanced Formatting - 2-D Pie Chart 3-2

The below pie chart is with new color format and style.
Advanced Formatting - 2-D Pie Chart 3-3

4. How do you Rotate a Slice and Increase the Space Between a Pie Chart?

  • Right-click on the pie chart and select Format Data Series.

Advanced Formatting - 2-D Pie Chart 4

The Format Data Series menu will open up on the right side.

  • Select “223°” under “Angle of first Slice” and “10%” under “Pie Explosion” to increase the gap between slices.

Advanced Formatting - 2-D Pie Chart 4-2

The pie chart will look like this,
Advanced Formatting - 2-D Pie Chart 4-3

5. How to Change the Font and Border Color?

  • Select the pie chart image.

A Format Chart Area menu will open.

You can try various styles combinations to make the pie chart more attractive. The options selected by us are given in the following image.
Advanced Formatting - 2-D Pie Chart 5

The pie chart will look like this,
Advanced Formatting - 2-D Pie Chart 5-2

Advanced Formatting: Pie of Pie Chart

1. How does changing the Pie of the Pie Chart change the font color?

  • Select the pie chart.

A Format Chart Area menu will appear on the right side.

  • Select the desired color under the “Text Fill” group of the “Text Options” tab.

Advanced Formatting - Pie of Pie Chart 1

2. How to Change the Format of the Pie of Pie Chart?

  • Right-click on the pie chart and select “Format Data Series“.

A Format  Data series menu will appear.

Select the following options under “Series Options“.
Advanced Formatting - Pie of Pie Chart 2

After selecting the above option, the pie of pie chart will look like this,
Advanced Formatting - Pie of Pie Chart 2-3

Advanced Formatting: Bar of Pie Chart

To make the bar of pie more attractive

  • Select the chart and click on the Paintbrush symbol, which appears on the right side of the chart. See the below image.

You can select any format. We have chosen the below design.
Advanced Formatting - Bar of Pie Chart 1

The bar of Pie with the selected style format will look like this,
Advanced Formatting - Bar of Pie Chart 2

Advanced Formatting: 3-D Pie Chart

1. How to Rotate the Pie Chart and Increase the Gap Between the Slices?

  • Right click on the chart and select “Format Data Series“.

A Format Data Series menu will appear on the right side.
Advanced Formatting - 3-D Pie Chart 1

  • Change the value of the “Angle of first slice” and “Pie Explosion” to the below condition.

Advanced Formatting - 3-D Pie Chart 2

The 3-D pie chart will appear as,
Advanced Formatting - 3-D Pie Chart 3

2. How to Change the Style Format/Design?

  • Select the desired style format, as shown below.

Advanced Formatting - 3-D Pie Chart 4

3-D pie with a new style format is ready.
Advanced Formatting - 3-D Pie Chart 5

Advanced Formatting: Doughnut Pie

1. How to Change the Style Format of the Doughnut Pie chart?

  • Select the desired style format, as shown below.

Advanced Formatting - Doughnut Pie 1

2. How to Decrease the Inside Gap of the Doughnut Chart.

Right-click on the pie chart and select Format Data Series.

  • Set “9° for the “Angle of the first slice” and “50%” for “Doughnut Hole Size.

Advanced Formatting - Doughnut Pie 2

The inside gap of the Dougnut pie chart decreased. See the below image.
Advanced Formatting - Doughnut Pie 3

Let’s change the color of the slices of the doughnut pie chart.
The final result after changing the colors is given below,
Advanced Formatting - Doughnut Pie 4

Things to Remember About Pie Chart Examples

  • Select data with proper categories or data points for creating a pie chart.
  • Pie charts are useful for representing the nominal and ordinal data categories.
  • Do not use negative or zero values data to create a pie chart. The pie chart will display the negative value as the positive value. So, there is no difference between the representation of positive and negative values.
  • Use data with a maximum of 7 categories or divisions to create a clutter-free pie chart.

Recommended Articles

This article is a step-by-step guide to Pie Chart Examples. Here we discuss how to create different pie charts in Excel and their customization with examples. You can also go through our other suggested articles:

  1. Excel Combination Charts
  2. Chart Wizard in Excel
  3. Pie Chart in Excel
  4. PivotChart in Excel

Primary Sidebar

Footer

Follow us!
  • EDUCBA FacebookEDUCBA TwitterEDUCBA LinkedINEDUCBA Instagram
  • EDUCBA YoutubeEDUCBA CourseraEDUCBA Udemy
APPS
EDUCBA Android AppEDUCBA iOS App
Blog
  • Blog
  • Free Tutorials
  • About us
  • Contact us
  • Log in
Courses
  • Enterprise Solutions
  • Free Courses
  • Explore Programs
  • All Courses
  • All in One Bundles
  • Sign up
Email
  • [email protected]

ISO 10004:2018 & ISO 9001:2015 Certified

© 2025 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you

EDUCBA

Download Pie Chart Examples Excel Template

EDUCBA
Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

By continuing above step, you agree to our Terms of Use and Privacy Policy.
*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA Login

Forgot Password?

EDUCBA

Download Pie Chart Examples Excel Template

EDUCBA

डाउनलोड Pie Chart Examples Excel Template

Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more

🚀 Limited Time Offer! - ENROLL NOW