Box and whisker plots

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
 
Hi,

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

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

- Jon
 
Back
Top