I am trying to make a pie chart that has 50 slices. Each slice of the
pie can have values that vary from 0 to 5. On the finished graph I
want a solid pie color of red color for all 50 slices set at 2.5 and a
variable color set at another color that will overwrite the red if it
exceeds 2.5 and show red and green if the variable is less than 2.5.
Any suggestions?

Thanks!

Michael -

Not sure if you really want two colors in the pie chart or three, but in
either case, why don't you use the 50 data points, and count those with less
than 2.5, count those more than 2.5, (and if you want the third color, count
those with exactly 2.5) in the responses, and graph those two or three
numbers?

If you really need to see 50 items, why not a histogram?

--
Daryl S


"Michael M" wrote:

I am trying to make a pie chart that has 50 slices. Each slice of the
pie can have values that vary from 0 to 5. On the finished graph I
want a solid pie color of red color for all 50 slices set at 2.5 and a
variable color set at another color that will overwrite the red if it
exceeds 2.5 and show red and green if the variable is less than 2.5.
Any suggestions?

Thanks!


.