Box and whisker plots

[Guest]

Can anyone help?

Does excel have a box plot graph function. i.e. like a bar chart except the
bars are "floating" with the top value on the box representing the 75th
centile, the bottom of the box representing the 25th centile, then error bars
from the top of the box representing 90th centile and error bars from bottom
of box representing 10th centile. I also would like to put a line within the
box representing the median.

Thanks

John

 

[Andy Pope]

Hi,

See Jon's page
http://peltiertech.com/Excel/Charts/BoxWhisker.html

Cheers
Andy

 

[Guest]

Hi Andy,

Does this work if some of my percentiles have negative values

I have followed the instructions but the box plots do not seem to correspond
to the percentile numbers

John

 

[Andy Pope]

Hi,

There appears to be a screen shot of a box plot with negative values so
I assume yes.

Cheers
Andy

 

[Jon Peltier]

The more advanced techniques successfully account for negative values for
the percentiles.

- Jon

 

[Jon Peltier]

You have to combine the more complicated data structure of this tutorial:

http://peltiertech.com/Excel/Charts/StackedColumnsAboveAndBelow.html

with the box and whisker example here:

http://peltiertech.com/Excel/Charts/BoxWhiskerV.html

The Box and Whisker Utility
(http://peltiertech.com/Excel/Charts/BoxWhisker.html) generates a box and
whisker chart from any data set, including sets with positive and negative
values.

- Jon