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

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

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

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

with the box and whisker example he

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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Wigi" wrote in message
...
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