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
Different Types of Pie charts:
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