box and whisker
 

I would like to see Excel have a box and whisker graph as an available chart
type. I have been unable to figure out how to teach Excel to do this.
Basically, for any set of data, you would calculate minimum, lower quartile,
median, upper quartile, and maximum. These would be graphed above a number
line. Please see http://ellerbruch.nmu.edu/cs255/jnord/boxplot.html for more
details.

Can anyone tell me how to get excel to do this?

Thanks.
Mike

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...excel.charting

box and whisker
 

Jon Peltier's website may have what you'r looking
forhttp://www.peltiertech.com/Excel/Charts/statscharts.html#BoxWhisker

"MrMike888" wrote:

I would like to see Excel have a box and whisker graph as an available chart
type. I have been unable to figure out how to teach Excel to do this.
Basically, for any set of data, you would calculate minimum, lower quartile,
median, upper quartile, and maximum. These would be graphed above a number
line. Please see http://ellerbruch.nmu.edu/cs255/jnord/boxplot.html for more
details.

Can anyone tell me how to get excel to do this?

Thanks.
Mike

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...excel.charting