Excel Pie Chart

Pie Chart in Excel

Pie chart is a type of circular excel chart which represents the visualization of data in circular format, in this circular chart every category of data has its own part and all the categories make it as a whole circular data, pie chart is a good type of chart for representation but there is a limitation to pie chart as it takes only two axis of data to represent.

Steps to Create a Pie Chart in Excel

Following are the steps to create pie chart in excel –

  1. Select the range A1:D2.


    Pie chart - step 1

  2. On the Insert tab, in the Charts group, click the Pie symbol.


    Pie chart - step 2

  3. Click Pie.


    Pie chart - step 3

  4. Click on the pie to select the whole pie. Click on a slice to drag it away from the center.


    Pie chart - step 4

    The pie chart shows the size of items in one data series, proportional to the sum of the items. The data points in a pie chart are shown as a percentage of the whole pie. To create a Pie Chart, arrange the data in one column or row on the worksheet.

Types

  • Pie
  • 3-D Pie
  • Pie of Pie
  • Bar of Pie
  • Doughnut

#1 – 3D Pie Chart in Excel

A 3d pie chart, or perspective pie chart, is used to give the chart a 3D look. Often used for aesthetic reasons, the third dimension does not improve the reading of the data; on the contrary, these plots are difficult to interpret because of the distorted effect of perspective associated with the third dimension. The use of superfluous dimensions not used to display the data of interest is discouraged for charts in general, not only for pie charts.

3D Pie Chart Examples

You can download this Pie Chart Excel Template here – Pie Chart Excel Template
  1. Click the Insert tab and choose 3-D Pie chart
Pie chart - step 6

If you want to create a pie chart that shows your company (in this example – Company A) in the greatest positive light:

Pie chart - step 7

Do the following:

  1.  Select the data range (in this example, B10:C15).
  2.  On the Insert tab, in the Charts group, choose the Pie button:
Pie chart - step 8

Choose 3-D Pie.

Pie chart - step 9
  1. Right-click in the chart area. In the popup menu, select Add Data Labels and then click Add Data Labels:
Pie chart - step 10
  1. Click on one of the labels to select all of them, then right-click and select the Format Data Labels… in the popup menu:
Pie chart - step 11
  1. In Format Data Labels opened in the Format task pane, on the Label Options tab, select the Category Name checkbox:
Pie chart - step 12
  1.  Open Format Data Series in the Format task pane:
  • In the Series Options section:

In the Angle of the first slice, move the sliding handle to the rotation degree that you want, or type a number between 0 and 360 degrees. The default setting is 0 degrees.

In the Pie, Explosion moves the sliding handle to the percentage of the explosion that you want or type a percentage between 0 and 400 in the text box. The default setting is 0%.

Pie chart - step 13
  • In the Effects section, in the 3-D Format group, make changes you want.

You can then make any other adjustments to get the look you desire.

#2 – Pie of Pie & Bar of Pie

If you have several parts of something whole, you can demonstrate each item in one pie chart. But, when several parts each amount to less than 10 percent of the pie, it becomes hard to distinguish the slices.

Pie chart - step 14

For example, if you have several companies that operate on the market, you can represent a part of every company on the market as a slice.

Pie chart - step 15

This data contains five slices that fall below 10%.

To make smaller slices more visible in a pie chart, Excel provides the Pie of Pie (see above), and Bar of Pie (see below) chart sub-types.

Each of these chart sub-types separates the smaller slices from the main pie chart and displays them in an additional pie or stacked bar chart in excelStacked Bar Chart In ExcelThe stacked bar chart in Excel represents data in the shape of bars, with the bars representing different segments or categories for comparison. A stacked bar chart is used to compare different types of data in terms of their values.read more. To create a Pie of Pie or Bar of Pie in excel, follow these steps:

  1.  Select the data range (in this example, B27:C36).
Pie chart - step 16
  1.  On the Insert tab, in the Charts group, choose the Pie button:
Pie chart - step 17

Choose Pie of Pie or Bar of Pie

Pie chart - step 18
Example
Pie chart - step 19
Example
Pie chart - step 20
  1. Right-click in the chart area. In the popup menu, select Format Data Series…

In the Format Data Series task pane, on the Series Options tab, select which data can be displayed in the second pie (in this example, in the second pie, we displayed all values less than 10%):

Pie chart - step 21

You can then make any other adjustments to get the look you desire.

#3 – Doughnut

The doughnut chart is a variant of the pie in excelDoughnut Chart Is A Variant Of The Pie In 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. While the two charts are quite similar in the way they look and function, the following features of the doughnut chart set them apart:

  • The doughnut chart has a cutout center.
  • The center of the doughnut chart can be used to render additional information like the total of all data values, as well as the data value of the slice being hovered upon. In this case, then, rendering data labels and data values separately are not required.

In Excel, click Insert > Insert Pie or Doughnut Chart > Doughnut. See screenshot:

step 23
Example

For example, if you have several companies that operate in one business, you can submit a part of every company in this business:

step 24

After the merger of some companies have received:

step 25

To create one chart of this data, follow these steps:

  1.  Select the first data range (in this example, B43:C48).
step 26
  1.  On the Insert tab, in the Charts group, select the Pie and Doughnut button and then choose Doughnut:
step 27
  1. Right-click in the chart area. In the popup menu, select Select Data…:
step 28
  1. In the Select Data Source dialog box, click the Add button:
step 29
  1. In the Edit Series dialog box, select the second data range (in this example C53:C61):
step 30

After adding a new data series, your doughnut chart can be like this:

step 31

Pie Chart in Excel Video

 

Recommended Articles

This has been a guide to Pie Chart in Excel. Here we discuss its uses and how to create Pie Chart in Excel along with excel example and downloadable excel templates. You may also look at these useful functions in excel –

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