quartile pie chart

[Barry Au]

Hi all,

I have a bunch of data that shows the time to fix a problem.

Is there a way to create a pie chart that splits the data into quartile.

so for example, on the pie chart, i want to see the percentage of problems that were solved under 3 hours, more than 3 less than 7hrs, more than 7 less than 10hours, and more than 10hours

thanks.

[sweep]

From your list of times you can calculate the quantiles hence:

=COUNTIF(range,"<3") for less than 3 hours
=COUNTIF(range,"<7")-COUNTIF(A7:A26,"<3") for 3 to 7 hours
=COUNTIF(A7:A26,"<10")-COUNTIF(A7:A26,"<7") for 7 to 10 hours
=COUNT(A7:A26)-COUNTIF(A7:A26,"<10") for greater than 10 hours

and plot these calculated values on your pie chart.