EDUCBA

EDUCBA

MENUMENU
  • Free Tutorials
  • Certification Courses
  • 120+ Courses All in One Bundle
  • Login
Home Excel Excel Resources Excel Charts Pie Chart in Excel
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 and 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 in Excel

By Jeevan A YJeevan A Y

Pie Chart in Excel

Excel Pie Chart ( Table of Contents )

  • Pie Chart in Excel
  • How to Make Pie Chart in Excel?

Pie Chart in Excel

Pie Chart in Excel is used for showing the completion or main contribution of different segments out of 100%. It is like each value represents the portion of the Slice from the total complete Pie. For Example, we have 4 values A, B, C and D. A total of them is considered 100 either in percentage or in number; there any value A would have its own contribution towards the completion of Pie formation, which is shown as Pie Chart.

How to Make Pie Chart in Excel?

Pie Chart is very simple to use. Let us now see how to make Pie charts in Excel with the help of some examples.

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

Example #1 – 2D Pie Chart in Excel

Look into the first example here. I have a top ten country population percentage over the world population. The first column contains a country name, and the second column contains the population percentage.

Start Your Free Excel Course

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

We need to show this in a graphical way. I have chosen a PIE CHART to represent slices of PIE.

Example 1-1

Follow the below steps to create your first PIE CHART in Excel.

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,768 ratings)

Step 1: Do not select the data; rather, place a cursor outside the data and insert one PIE CHART. Go to the Insert tab and click on a PIE.

Pie Chart Example 1-2

Step 2: once you click on a 2-D Pie chart, it will insert the blank chart as shown in the below image.

Pie Chart Example 1-3

Step 3: Right-click on the chart and choose Select Data.

Pie Chart Example 1-4

Step 4: once you click on Select Data, it will open the below box.

Pie Chart Example 1-5

Step 5: Now click on the Add button.

Pie Chart Example 1-6

it will open the below box.

Pie Chart Example 1-7

In the Series Name, I have selected the heading as a percentage.

In the Series Values, I have selected all the countries percentage values ranging from B2 to B11.

Pie Chart Example 1-8

Step 6: Click on OK.

Pie Chart Example 1-9

Step 7: Now click on the Edit option.

Pie Chart Example 1-10

Step 7: Here, we need to select the values that we need to show horizontally. Horizontally we need to show all the countries names. Countries names are ranging from A2 to A11.

Pie Chart Example 1-11

Step 8: Now, finally click on, OK.

Pie Chart Example 1-12

Your PIE CHART is ready.

Pie Chart Example 1-13

Step 9: This is not yet the fully finished chart. We need to do some formatting to it. First, change the heading of the chart.

Click on the heading

Pie Chart Example 1-14

and type your heading.

Pie Chart Example 1-15

Step 10: Now, right-click on one of the slices of the pie and select add data labels.

Pie Chart Example 1-16

This will add all the values we are showing on the slices of the pie.

Pie Chart Example 1-17

Step 11: You can expand each pie differently. Right-click on the pie and select Format Data Series.

Pie Chart Example 1-18

Step 12: Now, you can expand the Pie Explosion according to your wish.

Pie Chart Example 1-19

Step 13: Now, your chart ready to rock.

Result of Example 1

In this way, we can present our data in a PIE CHART makes the chart easily readable.

Example #2 – 3D Pie Chart in Excel

Now we have seen how to create a 2-D Pie chart. We can create a 3-D version of it as well. For this example, I have taken sales data as an example. I have a sale person name and their respective revenue data.

Example 2

Step 1: Select the data to go to Insert, click on PIE, and select 3-D pie chart.

Example 2-1

Step 2: Now, it instantly creates the 3-D pie chart for you.

Example 2-2

Step 3: Right-click on the pie and select Add Data Labels.

 Example 2-3

This will add all the values we are showing on the slices of the pie.

 Example 2-4

Step 4: Select the data labels we have added and right-click and select Format Data Labels.

 Example 2-5

Step 5: Here, we can so many formatting. We can show the series name along with their values, percentages. We can change these data labels’ alignment to center, inside end, outside end, Best fit.

 Example 2-6

Step 6: Similarly, we can change the color of each bar, change the legends space, adjust the data label show etc.… Finally, your chart looks presentable to the reader or the user.

Result of Example 2

Advantages:

  • Large data can be presented by using the Pie Chart in Excel.
  • With the help of each slice bar, we can easily compare one with another.
  • Easy and no need to explain it to the end-user. It is understandable by any means.

Disadvantages:

  • Fitting data labels in the case of smaller values is very difficult. It will overlap with other data labels.
  • If there are too many things to show, it will make the chart look ugly.

Things to Remember

  • Do not use 3D charts quite often. 3D chart significantly distorts the message.
  • Instead of using legends, try to show them along with the data labels. This will be very much understandable to the users.
  • Use a different color for each slice and make the chart look beautiful to watch.
  • Try to explore each slice by a maximum of 8%. Do not go beyond that threshold limit.
  • If the labels are fewer, less we can compare easily with the other slices. If there are too many values, try using a column chart instead.

Recommended Articles

This has been a guide to Pie Chart in Excel. Here we discuss how to create Pie Chart in Excel along with practical examples and a downloadable excel template. You can also go through our other suggested articles –

  1. Histogram Chart Excel
  2. Interactive Chart in Excel
  3. Surface Charts in Excel
  4. Excel Animation Chart
Popular Course in this category
Excel Advanced Training (16 Courses, 23+ Projects)
  16 Online Courses |  23 Hands-on Projects |  140+ Hours |  Verifiable Certificate of Completion
4.8
Price

View Course

Related Courses

Excel Data Analysis Training (17 Courses, 8+ Projects)4.9
Excel for Marketing Training (8 Courses, 13+ Projects)4.8
0 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 Excel Template

EDUCBA

Download Pie Chart Excel Template

EDUCBA

डाउनलोड Pie Chart 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