Make Pie Chart in Excel

How to Make a pie chart in Excel?

There are different kinds of Pie charts in excelPie Charts In ExcelThe pie chart is a circular excel chart representing the visualization of data in a circular format. In this circular chart, every category of data has its part, and all the categories make it as a whole circular data.read more which can be used as per the requirement. Below we have taken examples to learn how to make excel pie charts.

  1. 2D Pie Chart
  2. 3D Pie Chart
  3. Pie of Pie
  4. Bar of Pie
  5. Doughnut Pie
Make Pie Chart in Excel

You are free to use this image on your website, templates etc, Please provide us with an attribution linkHow to Provide Attribution?Article Link to be Hyperlinked
For eg:
Source: Make Pie Chart in Excel (wallstreetmojo.com)

Example #1 – Make a 2D Pie Chart

In this example let’s learn how to make the 2D Pie chart in excel

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


Here let’s take data of the Food industry to see which flavor beverage is more selling and has more demand.

  1. Enter the data in an excel sheet


    Pie Chart Example 1

  2. Select the range of data ie., A1: B8 then click on Insert tab in the Ribbon and click on the Pie Chart icon in the Charts section and select the first chart under 2-D Pie Option.

    Make a Pie Chart Excel Example 1-1

  3. The Pie Chart looks like as given below:


    Pie Chart Example 1-2

    This is how the 2D pie chart looks like.  In this chart, you can see the circle shaped chart representing the data and each slice of the pie represents the flavor.

    By looking at this chart, one can easily compare the data and the Mango flavor has the highest Sales which means high demand followed by Strawberry flavor.

    You can add data labels to the slices to get the values of each slice. (As shown in the figure)

  4. Right-click on the chart and select Add Data Labels > Add Data Labels Option.


    Pie Chart Example 1-3

  5. Data Labels is added to the chart.


    Pie Chart Example 1-4

  6. Selecting Add Call Outs shows the data labels with name and % to total as a call-out outside the chart.


    Pie Chart Example 1-4
    You can drag the slice out from the circle to visualize the data by highlighting the bigger slice or the smaller slice.  Just double click on the particular slice and drag it using a mouse.

    In the below-given figure, I’ve taken out the slices having the highest Sales and least Sales.

  7. These slices can be rejoined to the circle by selecting and dragging it back to its place.


    Pie Chart Example 1-6

    The color of the slices can be customized using the Format Data Point option

  8. Double click on the slick and right-click and select the option “Format Data Point” in the options.


    Pie Chart Example 1-7

  9. Select the color under the “Fill” section.


    Pie Chart Example 1-8

    The angle of the slices can be changed to make it show in the angle wherever you want.

  10. Click and select the chart and do right click then, select Format Data Series from the option.


    Pie Chart Example 1-9
    Adjust the Angle of first slice bar to change the direction of the slices under Series Options section

  11. Adjust the Pie Explosion bar to increase or decrease the gap between the slices.


    Pie Chart Example 1-10

    Pie Chart Example 1-11

  12. The appearance of the chart can be changed using the chart styles option available at the right top corner of the chart.


    Pie Chart Example 1-12

  13. The categories of the pie can be removed/applied by using the chart filter.


    Pie Chart Example 1-13

Example #2 – Make a 3D Pie Chart

To make the 3D Pie chart in excel, follow the same steps as given in the previous example.

  • Enter the data in an excel sheet and click on the Pie Chart icon in the Charts section and select the chart under 3-D Pie Option.
Make a PieChart in Excel Example 2

Then the Chart looks like as given below:

Pie Chart Example 2-1

In this example, we have two data sets. But the pie chart can show data on one column only. This type of chart is currently showing the data on Actual Sales. To see the chart for Target Sales, you need to switch the columns in Chart filter (as shown below).

Example 2-2

Now you can see the Target Sales data.

Pie Chart Example 2-3

All the other options and features of the 3D pie chart remain the same as 2D pie.  The features explained in the above 2D chart can be applied to this chart as well.

Example #3 – Make a Doughnut Pie Chart

The doughnut pie chart excelDoughnut Pie Chart ExcelA doughnut chart is a type of excel chart whose visualization is similar to pie chart. The categories in this chart are parts that, when combined, represent the whole data in the chart. A doughnut chart can only be made using data in rows or columns.read more is one of the types in Pie chart which will be in the shape of Doughnut, which is only the outer circle and hollow inside. The advantage of using a doughnut chart is that you can show the multiple data sets in the chart, unlike other pie charts.

To make the doughnut pie chart in excel, please follow the same steps as given in the previous examples.

  • Select the data in an excel sheet and click on the Pie Chart icon in the Charts section and select the Doughnut chart.
Make a PieChart in Excel Example 3

The Doughnut Chart would look like as given below:

Pie Chart Example 3-2

In the above example, I’ve taken three data sets for three different months showing the Sales.  And, the chart has three circles representing the three sets of data.  The innermost circle represents the value of the first column and outermost represents the data of the last column.

The disadvantage of this chart is it makes the chart difficult to read.

All the other options and features are as same as a 2D pie chart which are explained in the previous examples.

Example #4 – Make a Pie of Pie Chart

Pie of Pie is one of the chart types in Pie chart where you can see two pie charts for the same data set. In this chart, the items in the data set can be grouped based on the positions in the data tableData TableA data table in excel is a type of what-if analysis tool that allows you to compare variables and see how they impact the result and overall data. It can be found under the data tab in the what-if analysis section.read more, value, percentage or can be customized as per the requirement.

To make this chart, please follow the same steps as given in the previous examples.

  • Select the data and click on the Pie Chart icon in the Charts section and select the Pie of Pie Chart.
Make a PieChart in Excel Example 4
Pie Chart Example 4-1

In the above example, you can see the Pie of Pie.  There are 7 items in the data set and in the chart, the first pie has 5 slices and the second pie has 3 slices.  The bigger slice in the first pie with the connecting lines to the second pie is the total of the second pie. This chart combines the value of all the smaller portions in the first pie and shows separately in the second pie.

By default, the second pie will have the data of the last 3 items in the list (by position).  This can be changed as per the requirement.

  • Select the chart and do right click then, select Format Data Series
Example 4-2
  • Select the option in the dropdown in Split Series by section if you want it by value, percentage or custom
  • Increase or decrease the number of values in the second plot i.e. the no. of slices in the second chart based on position.
Example 4-3

Example #5 – Make a Bar of Pie Chart

The bar of the pie chart is as same as Pie of pie but the second chart will have the bar chart instead of Pie. Below given is the example for Bar of Pie.

  • Select the Data and click on the Pie chart option under that select Bar of Pie.
Make a PieChart in Excel Example 5

The Bar of Pie Chart looks like as given below.

Pie Chart Example 5-1

All the options and features will be the same as shown in the previous examples.

Recommended Articles

This has been a guide to make Pie Chart in Excel. Here we discuss how to make the top 5 types of pie-charts including 2D, 3D, Pie of Pie, Bar of Pie & Doughnut Chart. You may learn more about excel from the following articles –

  • 35+ Courses
  • 120+ Hours
  • Full Lifetime Access
  • Certificate of Completion
LEARN MORE >>