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:
[TABLE="width: 287"]
<colgroup><col><col span="2"></colgroup><tbody>[TR]
[TD]Category[/TD]
[TD]Number[/TD]
[TD]Percentage[/TD]
[/TR]
[TR]
[TD]Migraine[/TD]
[TD="align: right"]42[/TD]
[TD="align: right"]23%[/TD]
[/TR]
[TR]
[TD]Unknown[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]3%[/TD]
[/TR]
[TR]
[TD]No Migraine[/TD]
[TD="align: right"]132[/TD]
[TD="align: right"]74%[/TD]
[/TR]
[TR]
[TD]In Support[/TD]
[TD="align: right"]99[/TD]
[TD="align: right"]75%[/TD]
[/TR]
[TR]
[TD]Not in support[/TD]
[TD="align: right"]34[/TD]
[TD="align: right"]26%[/TD]
[/TR]
</tbody>[/TABLE]
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:
[TABLE="width: 287"]
<colgroup><col><col span="2"></colgroup><tbody>[TR]
[TD]Category[/TD]
[TD]Number[/TD]
[TD]Percentage[/TD]
[/TR]
[TR]
[TD]Migraine[/TD]
[TD="align: right"]42[/TD]
[TD="align: right"]23%[/TD]
[/TR]
[TR]
[TD]Unknown[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]3%[/TD]
[/TR]
[TR]
[TD]No Migraine[/TD]
[TD="align: right"]132[/TD]
[TD="align: right"]74%[/TD]
[/TR]
[TR]
[TD]In Support[/TD]
[TD="align: right"]99[/TD]
[TD="align: right"]75%[/TD]
[/TR]
[TR]
[TD]Not in support[/TD]
[TD="align: right"]34[/TD]
[TD="align: right"]26%[/TD]
[/TR]
</tbody>[/TABLE]
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