Hi

Have a look he

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

and scroll down to "Box and whisker plots"

--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music


"JRD" wrote:

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