EDUCBA

EDUCBA

MENUMENU
  • Free Tutorials
  • Certification Courses
  • 120+ Courses All in One Bundle
  • Login
Home Excel Excel Resources Excel Charts Pie Chart Examples
Secondary Sidebar
Excel Functions
  • Excel Charts
    • Excel Data Visualization
    • Dashboard in Excel
    • Bullet Chart in Excel
    • Excel Animation Chart
    • Plots in Excel  
    • Interactive Chart in Excel
    • Surface Charts in Excel
    • Excel Calendar Template
    • Thermometer Chart in Excel
    • Box Plot in Excel
    • S CURVE in Excel
    • Venn Diagram in Excel
    • Project Management with Gantt Chart
    • Change Chart Style in Excel
    • 3D Scatter Plot in Excel
    • Box and Whisker Plot in Excel
    • Radar Chart in Excel
    • Control Charts in Excel
    • Dot Plots in Excel
    • Marimekko Chart Excel
    • Combo Chart in Excel
    • Contour Plots in Excel
    • Candlestick Chart in Excel
    • Map Chart in Excel
    • Pie Chart Examples
    • Excel Stacked Bar Chart
    • Excel Flowchart
    • Excel Types of Graphs
    • Excel Normal Distribution Graph
    • Excel Bell Curve
    • Legends in Excel Chart
    • Excel Chart Templates
    • Excel Organization Chart
    • Excel Doughnut chart
    • Excel 3D Plot
    • Excel Scatter Chart
    • Excel Line Chart
    • Excel Combination Charts
    • Excel Gauge Chart
    • Excel Pivot Chart
    • Excel Clustered Column Chart
    • Excel Dynamic Chart
    • Excel Stacked Column Chart
    • Excel Bubble Chart
    • Histogram Chart Excel
    • Excel Gantt Chart
    • Excel Stacked Area Chart
    • Excel Waterfall Chart
    • Excel Area Chart
    • Excel Clustered Bar Chart
    • Excel Column Chart
    • Excel Pie Chart
    • Comparison Chart in Excel
    • Pareto Analysis in Excel
    • Add a Secondary Axis in Excel
    • Grouped Bar Chart
  • Excel Functions (12+)
  • Excel Tools (114+)
  • Financial Functions in Excel (17+)
  • Logical Functions in Excel (14+)
  • Lookup Reference Functions in Excel (35+)
  • Maths Function in Excel (47+)
  • TEXT and String Functions in Excel (26+)
  • Date and Time Function in Excel (24+)
  • Statistical Functions in Excel (59+)
  • Information Functions in Excel (4+)
  • Excel Tips (222+)
  • Workplace Productivity (4+)
  • Microsoft Office Tools (15+)
  • Excel Formula and Functions (22+)
  • MS Excel Shortcuts (4+)
Excel Functions Courses
  • EXCEL ADVANCED COURSE
  • Excel Data Analysis Course
  • Excel for Marketing Course

Pie Chart Examples

By Madhuri ThakurMadhuri Thakur

pie chart examples

Pie Chart Examples (Table of Contents) 

  • Definition of Pie Chart
  • Types of Pie Charts

Definition of Pie Chart

PIE Chart can be defined as a circular chart with multiple divisions in it, and each division represents some portion of a total circle or total value. Simply each circle represents the total value of 100 per cent, and each division contributes some per cent to the total.

Start Your Free Excel Course

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

Examples of Types of Pie Charts

There are different types of PIE charts available in excel. We can view that by clicking on a Pie chart drop-down option.

All in One Excel VBA Bundle(120+ Courses, 30+ Projects)
Basic ExcelAdvanced ExcelVBA & MacrosExcel Dashboards
Pivot TablesStatistical FunctionsFinancial FunctionsCharts & Graphs
Price
View Courses
120+ Online Courses | 30+ Projects | 500+ Hours | Verifiable Certificates | Lifetime Access
4.9 (64,412 ratings)
You can download this Pie Chart Examples Excel Template here – Pie Chart Examples Excel Template

1. 2D Chart

Click on the Insert option that available on the top, as shown in the below image.

pie example in excel

Go to the charts segment and select the drop-down of Pie chart, which will show different types of PIE charts available in excel.

So, we have 3 different charts under the 2D pie and one under the 3D pie and one under Doughnut. We will see all those charts one by one with an explanation. We can use the same data for all those charts.

We will take a very small data table that is related to employee salary usage. Observe the below table, which expresses the expenses of the employee.

pie example in excel 1

The creation of a PIE chart is very easy. Select the data of the table.

pie example in excel 2

Now go to PIE chart options which are already explained earlier. Select the type of PIE chart we want to create. First, we will select the first PIE chart from 2D charts. The chart will look like below.

pie charts in excel 2

A PIE chart is created with different divisions, and each division is represented with different colors. At the bottom, there is a legend that will help to understand what color represents what division on the chart.

But it will be difficult to check the description in the legend and check it on the chart. Now our task is to add the Data series to the PIE chart divisions.

Click on the PIE chart so that the chart will get a highlight, as shown below.

pie charts in excel 3

Right-click and choose the “Add Data Labels “option for additional drop-down options. From that drop-down, select the option “Add Data Callouts”.

pie charts in excel 4

Once we choose “Add Data Callout”, the chart will have details like below.

pie charts in excel 5

Now each division on the chart represents its name and contributed percentage. In case if we want to add the amount alone to the division. Click on the “+” symbol and select the Data labels option.

pie example in excel 1-1

In case if we want to add the expenses category to the division. Select the chart, and right-click from the popup menu; select the “Format data labels.”

pie example in excel 1-2

From the “Format Data Labels” menu on the right-hand side. Select the “Category Name” and deselect the value if we want both; select both options.

pie example in excel 1-3

If we want to change the design, a “Design” menu will appear on the top when we select the chart, and we can select the required design.

pie example in excel 1-5

If we want to change the colors of the division, select the required division as below.

pie example in excel 1-6

When we select a division, a “format data point” menu will appear from that menu change the color on the right side.

pie example in excel 1-7

2. PIE of PIE Chart

Now with the same data, we will create a PIE of the PIE chart. To create this, we just need to choose the Pie of pie option instead of Pie chart as earlier.

pie of pie chart - 1

In this pie of pie chart, we will have two pie charts. The first one is a normal Pie chart, and the second one is a subset of the main pie chart. If we add the labels, then we will understand what is covered in the sub chart.

Sub Chart

The sub chart has only two categories which are representing the break up of 3900. If we add the labels, then it will show what categories cover the sub Pie chart.

sub Pie chart

The pie chart has school fees and savings, representing as other in the main part chart.

3. Bar of PIE Chart

Now, while creating the chart, just select the Bar of Pie chart then the below chart will be created.

Bar of Pie chart

It is similar to Pie of the pie chart, but the only difference is that instead of a sub pie chart, a sub bar chart will be created. With this, we have completed all the 2D charts, and now we will create a 3D Pie chart.

4. 3D PIE Chart

A 3D pie chart is similar to PIE, but it has depth in addition to length and breadth.

3D Chart

If we want to separate the divisions, right-click on the chart and select the Format data series. Select the series option and increase the Pie explosion highlighted with a blue color box for reference.

Separate the Divisions

To rotate the chart, adjust the “Angle of first slice” option.

Rotating the Chart

5. Doughnut Chart

The doughnut chart looks different from the other pie charts because this pie chart has a hole in the middle. With that hole, it looks like a Doughnut; that is the reason it is referred to as a Doughnut chart.

Doughnut Chart

It looks like a ring, but it will look like a Doughnut below if we reduce the hole size.

Hole Ring

To reduce the hole size, right-click on the chart, select the Format Data Series, and reduce the hole size. Try other options like color change, soften edges, doughnut explosion, etc., as per our requirement.

If we add another additional line item at the bottom, we need to edit the data. Right-click on the chart and choose the “select Data “ option.

Data option

The below menu will appear from that click on the “Edit” option.

Edit Option

If we choose Edit, the below pop up will come. Change the series values to H8 to H9.

More Divisions

Click on Ok, and then the PIE chart will add one more division as below.

pie examples 5-6

Things to Remember About Pie Chart Examples

  • Do not use negative values as it will not show any difference in the chart, and it may create confusion too.
  • It is advisable to use not more than 7 segments or division as more number of divisions will not look that much clear for visibility.
  • Try to use different colors for each division if the system creates a few similar colors because the similar colors may difficult to differentiate divisions.
  • PIE charts are useful for representing the nominal and ordinal data categories.

Recommended Articles

This is a guide to Pie Chart Examples. Here we discuss Types of Pie Chart in Excel along with practical examples and downloadable excel template. You can also go through our other suggested articles –

  1. Excel Combination Charts
  2. Chart Wizard in Excel
  3. Pie Chart in Excel
  4. Pie Chart In MS Excel
Popular Course in this category
Excel Training (23 Courses, 9+ Projects)
  23 Online Courses |  9 Hands-on Projects |  110+ Hours |  Verifiable Certificate of Completion
4.9
Price

View Course

Related Courses

Excel Advanced Training (16 Courses, 23+ Projects)4.9
Excel Data Analysis Training (17 Courses, 8+ Projects)4.8
Excel for Marketing Training (8 Courses, 13+ Projects)4.7
4 Shares
Share
Tweet
Share
Primary Sidebar
Footer
About Us
  • Blog
  • Who is EDUCBA?
  • Sign Up
  • Live Classes
  • Corporate Training
  • Certificate from Top Institutions
  • Contact Us
  • Verifiable Certificate
  • Reviews
  • Terms and Conditions
  • Privacy Policy
  •  
Apps
  • iPhone & iPad
  • Android
Resources
  • Free Courses
  • Excel Charts
  • Excel Tips
  • All Tutorials
Certification Courses
  • All Courses
  • Excel VBA Course - All in One Bundle
  • VBA Course
  • Excel Data Analysis Course
  • Excel for Marketing Course
  • Excel for Finance Course
  • Excel for HR Training

ISO 10004:2018 & ISO 9001:2015 Certified

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

EDUCBA
Free Excel Course

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

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

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA Login

Forgot Password?

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA
Free Excel Course

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

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

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

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

By signing up, you agree to our Terms of Use and Privacy Policy.

Let’s Get Started

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

Download Pie Chart Examples Excel Template

EDUCBA

Download Pie Chart Examples Excel Template

EDUCBA

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

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more