Any affiliate commissions that weĮarn when you click a link to Amazon or other sites is reinvested in keeping Website are provided 'as is' and we do not guarantee that they can be used in all The Formulas, Functions and Visual Basic procedures on this provides examples of Formulas, Functions and Visual Basic proceduresįor illustration only, without warranty either expressed or implied, includingīut not limited to the implied warranties of merchantability and/or fitness forĪ particular purpose. You to specify that the secondary pie should be split by percentage, value, or number of items. Right-click the pie and choose Format Data Series. You can control which slices end up in the secondary pie. Small slices are moved to a secondary chart: If you have too many small slices, switch the chart type to a Bar of Pie type chart. In the bottom image, there are more room for the small slice labels: In the top image, the labels are crowded at the top. In Excel 2003, click on the Options tab and change the Angle of First Slice. In Excel 2007, the Angle of First Slice slider is first in the Series Options pane.Right-click on the pie and choose Format Series.Rotate the pie so that the small slices are in the lower right. If you have many tiny slices, the labels tend to overwrite each other. Drag that wedge away from the center of the pie.Now, only that one data point is selected. Create a regular (unexploded) pie chart.Rather than exploding the entire pie, it is more interesting to explode one slice of the pie. Instead, use a 2-D pie, where 30% looks like 30% whether it is at the top or the bottom: Here, both pies in this image have 30% for Labor, but the lower pie has 107% more dark blue pixels. Which ever slice is in the front appears much larger. What if you need to show changing pies over time? Switch to a stacked bar chart:Īvoid 3-D Pie charts. Also, some cool tricks for sweeter pie charts.Ī pie chart should be used to show components that add up to a whole: In this segment, we will take a look at when you should use a pie chart and when you should not. Way too many charts rely on the pie chart.

Create pie chart in excel