Creating a “Pie of Pie" Chart
Method 1 – Creating Directly From Data
This first method describes how to create a “pie of pie" chart directly from data entered into a spreadsheet.
Highlight the data that you want to use to create your chart. Open the Insert tab on the Excel ribbon, and expand the Pie menu in the Charts section. Select the Pie of Pie chart in the 2-D Pie portion of the menu. (Click image below for a larger view.)
This action will create a basic “pie of pie" chart like the one shown in the following screenshot.
If you don’t like this presentation, the layout and design can be modified using the same process as described in Part 2 of this series.
Method 2 – Creating From Another Pie Chart
This second method of creation is more common, because you don’t usually realize you need a “pie of pie" chart until you have tried to create a basic pie chart and found that you don’t like the way it looks.
Assume you already have created another type of pie chart and want to convert it to a “pie of pie" chart. As an example, we’ll use the pie chart constructed in Part 2 of this article.
Right-click anywhere on the pie chart and select Change Chart Type.
In the new window that opens, select the Pie of Pie chart.
The new chart will replace the old one in your Excel spreadsheet.
Again, as above, if you want to make any changes to the layout or design, you can use the same methods described in Part 2 of this series.
If you're interested in learning more about creating other types of charts, be sure to browse through the collection of Excel chart and graph tutorials found here at Bright Hub.
For more details on how to modify what data is shown in the second pie chart, continue on to the next page.