Excel Graphing

[Michael M]

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!

 

[teylyn]

You better re-think your approach. Pie charts with more than thre
slices are absolutely useles. The user will not be able to glean an
information from the slice size. You'll have to complement it with th
numbers, either on the slices (although there won't be enough space
will there?) or in a data table. So, you may as well skip the pi
altogether and just display the data table.

Or have a look at http://tinyurl.com/3jw9zf and learn about better way
to present data ...

 

[Michael M]

You better re-think your approach. Pie charts with more than three
slices are absolutely useles. The user will not be able to glean any
information from the slice size. You'll have to complement it with the
numbers, either on the slices (although there won't be enough space,
will there?) or in a data table. So, you may as well skip the pie
altogether and just display the data table.

Or have a look athttp://tinyurl.com/3jw9zfand learn about better ways
to present data  ...

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!

--
teylyn

Telyn  --  'teylyn.posterous.com' (http://teylyn.posterous.com)
------------------------------------------------------------------------
teylyn's Profile:http://www.thecodecage.com/forumz/member.php?userid=983
View this thread:http://www.thecodecage.com/forumz/showthread.php?t=158254

Microsoft Office Help

The objective of the pie chart is not to have varying sizes of pie
slices. It is to reflect the rating people have given to questions
asked in a survey where they are rating the degree that they agree
with a statement. The scale goes from 1 to 5 with 1 being strongly
disagree to 5 strongly agree. If they voted a 1 green would appear
from the 0 to the 1 and red would appear from the 1 to the 2.5 because
the red would be reflected in the graph as a solid circle out to the
2.5 unit measurement. If they voted a 5 the slice would be all
green.

As a result you can easily see where people (500) agree with things
versus disagree.. Each slice has a one or two word desrciption and
allows viewers to easily see the weak spots and strong spots. The
bigger the green slice the more people agree the bigger the red
exposure the stronger they disagree.

Any other thoughts?

 

[Daryl S]

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?

 

[Jon Peltier]

A pie would be very hard to interpret, especially with fifty slices.

You would probably have better results with a horizontal bar chart. Make
the chart taller than it width. The labels can be reasonably
descriptive. Rather than using colors (did you know 8-10% of the male
population has some degree of color-blindness?), let the bar length
indicate level of approval.

- Jon
-------
Jon Peltier
Peltier Technical Services, Inc.
http://peltiertech.com/

You better re-think your approach. Pie charts with more than three
slices are absolutely useles. The user will not be able to glean any
information from the slice size. You'll have to complement it with the
numbers, either on the slices (although there won't be enough space,
will there?) or in a data table. So, you may as well skip the pie
altogether and just display the data table.

Or have a look athttp://tinyurl.com/3jw9zfand learn about better ways
to present data ...

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!

--
teylyn

Telyn -- 'teylyn.posterous.com' (http://teylyn.posterous.com)
------------------------------------------------------------------------
teylyn's Profile:http://www.thecodecage.com/forumz/member.php?userid=983
View this thread:http://www.thecodecage.com/forumz/showthread.php?t=158254

Microsoft Office Help

The objective of the pie chart is not to have varying sizes of pie
slices. It is to reflect the rating people have given to questions
asked in a survey where they are rating the degree that they agree
with a statement. The scale goes from 1 to 5 with 1 being strongly
disagree to 5 strongly agree. If they voted a 1 green would appear
from the 0 to the 1 and red would appear from the 1 to the 2.5 because
the red would be reflected in the graph as a solid circle out to the
2.5 unit measurement. If they voted a 5 the slice would be all
green.

As a result you can easily see where people (500) agree with things
versus disagree.. Each slice has a one or two word desrciption and
allows viewers to easily see the weak spots and strong spots. The
bigger the green slice the more people agree the bigger the red
exposure the stronger they disagree.

Any other thoughts?