Box plots

[Guest]

Can anyone help?

I need to plot my data as a box plot (representing 25th and 75th centile)
with error bars representing 10th and 90th centile. Mr Andy Pope gave me a
solution but unfortunately it is not working as my 25th centile data is often
negative and therefore the stacked column method does not work.

Thanks

John

 

[Guest]

Hi

Have a look here:

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

and scroll down to "Box and whisker plots"

 

[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

Alternatively 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