Pie of Pie

i have three measures:
Met all criteria - 63
One criteria missed - 30
Two or more criteria missed - 7

this is a 100 count sample of a larger population. there are about 15
criteria total.

i want to draw out the 30 count slice and show what it makes it up. eg....of
these 30, there were 1 X, 20 Y, 9 Z.

can anyone tell me how to do this?

Hi,

Jon Peltier has written an article which should help you.
http://pubs.logicalexpressions.com/P...cle.asp?ID=471

Cheers
Andy

Texas Legend wrote:
> i have three measures:
> Met all criteria - 63
> One criteria missed - 30
> Two or more criteria missed - 7
>
> this is a 100 count sample of a larger population. there are about 15
> criteria total.
>
> i want to draw out the 30 count slice and show what it makes it up. eg....of
> these 30, there were 1 X, 20 Y, 9 Z.
>
> can anyone tell me how to do this?
>
>

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info