Most of the time, the problem you will need to solve will be more complex than a simple application of a formula or function. Output: How to explode a pie chart Instant Connection to an Excel Expert Pull the slice for Bulge and Lip away from the pieįigure 9. Directly pull the slice or slices apart.Customizing the pie of pie chart How to explode a pie chart? Second plot contains all values less than: 10%įigure 6. We can launch Format Data Series by right-clicking the chart and selecting from the menu. Following the same procedure as the example above, we choose the chart type pie of pie and create the resulting graph below.

To improve the presentation of our data, we can create a pie of pie chart. There are so many categories in the above pie chart, making it look complicated and harder to read. If we choose to make a 3D pie chart, it will look like this. Click Insert tab, Pie button then choose from the selection of pie chart types: Pie, Exploded Pie, Pie of pie, Bar of pie, or 3D pie chart.First, we select the data we want to graph.Just like any chart, we can easily create a pie chart in Excel version 2013, 2010 or lower. Final result: Pie of pie chart How to create a pie chart? This chart makes the pie chart less complicated and easier to read.įigure 1. It is actually a double pie chart, which displays the parts of a whole through a main pie, while also providing a way to represent the minor slices through another pie. Excel has a built-in chart type called pie of pie chart.

How ot make a pie chart in excel