Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Graphing
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! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Graphing
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! . |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Graphing
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/ Michael M wrote: On Dec 1, 4:08 am, teylyn wrote: 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 ... Michael M;572833 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! -- 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/sh...d.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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
xy coordinate graphing in excel | Excel Discussion (Misc queries) | |||
Graphing in Excel | Excel Discussion (Misc queries) | |||
Graphing in EXCEL | New Users to Excel | |||
MS EXCEL graphing | Excel Discussion (Misc queries) | |||
How to use just the graphing capabilities of MS Excel? | Excel Discussion (Misc queries) |