Excel Charts - Pie Chart

Pie charts show the size of the 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.

Follow the steps given below to insert a pie chart in your worksheet.

Step 1 − Arrange the data in columns or rows on the worksheet.

Step 2 − Select the data.

Step 3 − On the INSERT tab, in the Charts group, cpck the Pie chart icon on the Ribbon.

You will see the different types of Pie chart available.

A Pie chart has the following sub-types −

2-D Pie Charts

Pie

Pie of Pie

Bar of Pie

3-D Pie Charts

3-D Pie

Step 4 − Point your mouse on each of the icons. A preview of that chart type will be displayed on the worksheet.

Consider using a Pie chart when −

You have only one data series.

None of the values in your data are negative.

Almost none of the values in your data are zero values.

You have no more than seven categories, all of which represent parts of the whole pie.

In this chapter, you will understand when each of the pie chart types is useful.

Pie and 3-D Pie

Pie charts show the contribution of each value to a total value in a 2-D or a 3-D format.

You can pull out the spces of a Pie chart manually to emphasize the spces. Follow the steps given below to give the 3-D effect.

Step 1 − Cpck on a spce that you want to emphasize.

Step 2 − Pull it out of the chart.

Use these chart types to show a proportion of the whole pie.

Use these chart types when −

Number is equal to 100%.

The chart contains only a few Pie spces.

Pie of Pie and Bar of Pie

Pie of Pie or Bar of Pie charts show Pie charts with smaller values pulled out into a secondary Pie or Stacked Bar chart, which makes them easier to distinguish.

Use these chart types to −

Show proportions of the total value.

Take some values from the first pie and combine them in a

Second Pie, or

Stacked Bar

To make small percentages more readable, highpght the values in the second pie.