How to Create Two Pie Charts in One

MORE INFORMATION

1. Enter the following data in a worksheet:

         A1:               B1: US    C1: Asia
         A2: Electronics   B2: .28   C2: .30
         A3: Automotive    B3: .16   C3: .24
         A4: Software      B4: .11   C4: .09
         A5: Textiles      B5: .185  C5: .16
         A6: Service       B6: .08   C6: .083
         A7: Other         B7: .185  C7: .127
   						

2. Enter the temporary values in cells B8 and C8. The temporary values should either be a very large or a very small value so that it is easily identified on the chart.

        A8: Temporary Values  B8: .90   C8: .90
   						

3. Select the following range of cells on the worksheet: A1:C8:
   1. On the Insert menu, click Chart, and then As New Sheet. In the ChartWizard box, click Next.
   2. Under "Select a chart type," click Combination, and then Next.
   3. Under "Select a format for the Combination chart," click chart type 1, and then click Next.
   4. Click Next again, and then click to select No under "Add a legend?" Click Finish.
4. On the Format menu, click Chart type. In the Chart Type box, click to select Group under Apply to, and then click Column group. Click Pie, and then click OK.
5. On the Format menu, click Chart type. In the Chart Type box, click to select Group under Apply To, and then click Line Group. Select Pie, and then click OK.
6. Click the largest slice of pie and hold down the left mouse button. Slide the pointer to the left until the pie slice separates from the rest of the pie slices.
   
   NOTE: The other slices of the pie chart should not separate from each other.
7. Switch back to the worksheet. Select cells A8:C8. On the Edit menu, click Clear All. The chart should display a pie chart on top of another pie chart. The top chart, or inner pie chart, represents the values in cells C2:C7. The bottom chart, or outer pie chart, represents the values in cells B2:B7.
8. Select the Legend. On the Edit menu, click Clear All.
9. To add Data Labels on the inner pie slices:
   1. Click the inner pie.
   2. On the Insert menu, click Data Labels.
   3. Click the Show Label and Percent option button under the Data Labels group box and click OK. This places the data labels for the inner pie on the outer pie. Manually drag the labels to their respective slices on the inner pie.
10. To add Data Labels on the outer pie slices:
    1. Click the outer pie.
    2. On the Insert menu, click Data Labels.
    3. Click the Show Label and Percent option button under the Data Labels group box and click OK. This places the data labels for the outer pie in the plot area of the chart. Manually drag the labels to their respective slices on the outer pie.