Pie Chart


Pie charts are used to display the contribution of each value (slice) to a total (pie).Pie charts can be used anytime you want to show what percent a particular item represents of a data series

Note: Pie charts always use one data series.For example, we need to create pie chart of different months individually.

1. To create a Pie chart for April month, select data A1:D2 (Title and april month expense) and Go to Insert-> in Chart group, select Pie chart.

Result: Pie chart is prepared. Change the design and layout of chart for better clarity. (Read more about Change Chart Layout and design in Excel)

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

pie chart

Different Types of Pie charts:

  • pie of pie chart
    Pie of Pie chart
  • Bar of Pie chart
  • Exploded Pie chart
  • Pie in 3-D chart

Here is the brief description of different types of pie charts and when it can be useful.

Pie of Pie Chart and Bar of Pie chart:

Pie charts are excellent for displaying data points as a percentage of the whole. However, if data points are less than 5 percent of the whole pie, it is difficult to distinguish the slices.To make smaller slices more visible in a pie chart, Excel provides the Pie of Pie and Bar of Pie 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, as shown in the above slideshow.

Exploded Pie: Exploded pie chart display the contribution of each part by emphasizing individual values.

Pie in 3-D: 3-D view of Pie chart.


2,808 total views, 2 views today

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>