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,

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

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"JRD" wrote in message
...
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

"Andy Pope" wrote:

Hi,

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

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"JRD" wrote in message
...
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,

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

Cheers
Andy

JRD wrote:
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" wrote:


Hi,

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

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"JRD" wrote in message
...

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

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

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Andy Pope" wrote in message
...
Hi,

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

Cheers
Andy

JRD wrote:
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" wrote:


Hi,

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

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"JRD" wrote in message
...

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

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

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
_______


"Jon Peltier" wrote in message
...
The more advanced techniques successfully account for negative values for
the percentiles.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Andy Pope" wrote in message
...
Hi,

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

Cheers
Andy

JRD wrote:
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" wrote:


Hi,

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

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"JRD" wrote in message
...

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