I am trying to do a pie within pie chart. I have 5 data values. I really want the first 3 to show on the main pie chart and then break one of those 3 values out into the additional two data points in my list.
How do I tell excel not to include these last 2 data points in the primary chart at all? How do I tell it which piece of the primary chart (No Migraine) I want broken out?
Here are my data points:
<colgroup><col><col span="2"></colgroup><tbody>
</tbody>
So, to be more specific, I want the pie within pie to show the break down of the 132 "No Migraine" people into either In Support (99) or Not In support (34)
When I select split series by position, it still includes those last 2 items in the first chart as well.
Thanks
How do I tell excel not to include these last 2 data points in the primary chart at all? How do I tell it which piece of the primary chart (No Migraine) I want broken out?
Here are my data points:
Category | Number | Percentage |
Migraine | 42 | 23% |
Unknown | 5 | 3% |
No Migraine | 132 | 74% |
In Support | 99 | 75% |
Not in support | 34 | 26% |
<colgroup><col><col span="2"></colgroup><tbody>
</tbody>
So, to be more specific, I want the pie within pie to show the break down of the 132 "No Migraine" people into either In Support (99) or Not In support (34)
When I select split series by position, it still includes those last 2 items in the first chart as well.
Thanks