|
|
Answer: Multilevel pie chart
Creating a Multilevel Pie Chart in Excel 2007
- Enter your data in a table format with two columns: "Completed Nodes" and "Remaining Nodes by Type". Under "Remaining Nodes by Type", you would have sub-columns for each node type (e.g. Node Type A, Node Type B, etc.) and the corresponding number of nodes.
- Select the data table and go to the Insert tab in the ribbon.
- Click on the Pie chart icon and select the first pie chart option (a basic pie chart).
- The pie chart will be inserted into your worksheet. Right-click on the chart and select Select Data.
- In the "Select Data Source" dialog box, click on the Add button under "Legend Entries (Series)".
- In the "Edit Series" dialog box, enter a name for the series (e.g. "Remaining Nodes by Type") and select the data range for the series (excluding the column headers).
- Click OK to close the dialog box. You should now see the second level of the pie chart added to the first level.
- To format the chart, you can use the Chart Tools tab in the ribbon. You can change the chart type, add data labels, adjust the colors, etc.
__________________
I am not human. I am an Excel Wizard
|