Make pie chart microsoft excel 2007

Pie of Pie With this subtype, you can break out one slice of a pie into its own, smaller pie which is itself broken down into slices. This chart is great for emphasizing specific data; it's demonstrated in the next chapter. Bar of Pie The bar of pie subtype is almost the same as the pie of pie subtype. The only difference is that the breakup of the combined slice is shown in a separate stacked bar, instead of a separate pie.

Pie in 3-D and Exploded Pie in 3-D This option is the pie and exploded pie types in three dimensions, tilted slightly away from the viewer for a more dramatic appearance. Since it's the same color-coding for both, I'd like to use the same legend for both charts so I can save space and make the charts a bit bigger for example, put the charts side-by-side and the legend below them in the middle. I can make the two separate charts and then just delete one legend and move the other one toward the middle, but it makes it tricky to get them sized the same and is a bit complicated to work with.

Is there a way to create them in one chart window so I can easily copy and paste into a PowerPoint? Was this reply helpful? Yes No. Download Example. Highlight the data that you would like to use for the pie chart. In this example, we have selected the range A1:B5. Select the Insert tab in the toolbar at the top of the screen.

Click on the Pie button in the Charts group and then select a chart from the drop down menu. Using Pie Charts and Doughnut Charts in Excel If you have several parts of something one, you can demonstrate each item in one pie chart.

But sometimes you want to demonstrate the changes of those parts and doughnut chart will help you to do this. Creating a twin or double thermometer chart "Thermometer" chart display the percentage of a task that's completed. How to create simple thermometer chart, see Creating a simple thermometer chart and Creating a glossy thermometer chart.

But sometimes it will be more informative to display two results in one chart. This tip is how to create a thermometer chart with two competitive columns.