Pie in pie, but how to NOT show the sub-pie?

[paris3]

I want a pie chart that just summarizes a set of small-value categorie
into "OTHER" but without a separate pie chart. In other words, the pi
chart shows the top three values as separate slices, and then lumps th
remaining in the OTHER slice. Pie-in-pie works, but I don't want th
second pie chart that details the OTHER slice.

Ideas

 

[Andy Pope]

Hi,

The easy way would be to create a dummy set of data in another column,
where you summarize the OTHER slice.

But if you want to do it via pie-of-pie try this.
Create you chart and put the correct OTHER slices in the second Pie.
Adjust the following
Set Pattern and Border to none for all slices in second pie.
Via the option tab whilst formating the second pie
Gap Width = 0
Size of Second pie = 5
Remove Series Lines

Reposition plot area.

I want a pie chart that just summarizes a set of small-value categories
into "OTHER" but without a separate pie chart. In other words, the pie
chart shows the top three values as separate slices, and then lumps the
remaining in the OTHER slice. Pie-in-pie works, but I don't want the
second pie chart that details the OTHER slice.

Ideas?

--

Cheers
Andy

http://www.andypope.info

 

[paris3]

Hi,

The easy way would be to create a dummy set of data in anothe
column,
where you summarize the OTHER slice.

I like the sound of this option better. Can you elaborate? Would ther
be a way to make it dynamic, so as data is modified, those value
falling under a certain percentage would fall under the OTHER slice

 

[paris3]

*I like the sound of this option better. Can you elaborate? Woul
there be a way to make it dynamic, so as data is modified, thos
values falling under a certain percentage would fall under the OTHE
slice? *

Grr, I just read that and it makes no sense. Let me elaborate.

I have two columns: one is a text description of the name of an event
and the other is the number of times the event occurs. I want the pi
chart to only show the events with, say, 5 or more incidents a
separate slices, with anything under 5 being collected together unde
the OTHER slice. The individual slices would be named according to th
first column's text.

There, that sounds better.

Thank

 

[Andy Pope]

Have a look at this worked example.
(http://www.andypope.info/ngs/ng22.htm)

Grr, I just read that and it makes no sense. Let me elaborate.

I have two columns: one is a text description of the name of an event,
and the other is the number of times the event occurs. I want the pie
chart to only show the events with, say, 5 or more incidents as
separate slices, with anything under 5 being collected together under
the OTHER slice. The individual slices would be named according to the
first column's text.

There, that sounds better.

Thanks

--

Cheers
Andy

http://www.andypope.info