XL97: How to Create a Pie Of Pie Chart or a Bar Of Pie Chart

ID: Q192063

The information in this article applies to:

Microsoft Excel 97 for Windows

SUMMARY

This article describes how to create a Pie Of Pie chart or Bar Of Pie chart in Microsoft Excel 97.

MORE INFORMATION

You can use a Pie Of Pie chart or a Bar Of Pie chart to graphically represent one component of a pie chart. The total value of one slice will be represented by multiple slices of another pie or by bars of a column. The data that is representing another value needs to be the last items of the data range.

The following example creates a Bar Of Pie chart. The first four items of data add up to 100% and the last three values represent the total for the category Stocks (the fourth piece of the pie).

   A1: Cash                   B1: 5%
   A2: Bonds                  B2: 20%
   A3: Other Investments      B3: 15%
   A4: Stocks                 B4: 60%
   A5: U.S. Stocks            B5: 20%
   A6: Canadian Stocks        B6: 10%
   A7: European Stocks        B7: 30%

Before you create the Bar Of Pie chart, you should remove (or hide) the data representing the total value of the pie slice that will be broken down from the data range. In this example, you should remove row four (Stocks) from the data. You will use the values below row four to represent the category Stocks.

The new data range with the fourth row hidden will appear as follows:

   A1: Cash                   B1: 5%
   A2: Bonds                  B2: 20%
   A3: Other Investments      B3: 15%
   A5: U.S. Stocks            B5: 20%
   A6: Canadian Stocks        B6: 10%
   A7: European Stocks        B7: 30%

To create this Bar Of Pie chart, follow these steps:

1. Select A1:B7. On the Insert menu, click Chart.

2. In the Chart Wizard, Step 1 of 4, for Chart type, click Pie. For

   Chart sub-type, click Bar Of Pie. Click Next.

3. In the Chart Wizard, Step 2 of 4, for Series In, click Columns.

   You may click Finish to create the chart.

4. To ensure that the last three values are represented in the Bar, click

   either the Pie or the Bar to select the entire data series. On the
   Format menu, click Selected Data Series. Click Options. Change the
   number in the "Second plot contains the last: values" box to 3. Click
   OK.

REFERENCES

For more information about creating a pie chart, click Contents And Index on the Help menu, click the Index tab in Excel 97 Help, type the following text

pie

and then double-click the selected text to go to the "Create a pie chart" topic. If you are unable to find the information you need, ask the Office Assistant.

Additional query words: XL97 exploding pie

Keywords          : kbdta kbchart xlui 
Version           : WINDOWS:97
Platform          : WINDOWS
Issue type        : kbhowto

Last Reviewed: November 5, 1998