Floating Bar with Quartile Ranks
 

I'm looking to create a floating bar chart separated into four quartiles to
plot some statistical data. For example, I'd be plotting the 5th percentile,
25th percentile, median, 75th percentile, and 95th percentile to separate the
bar into 4 sections. I would then overlay another data point that fits into
one of those sections. Any suggestions on how to do that?

Floating Bar with Quartile Ranks
 

On Thu, 21 Aug 2008, in microsoft.public.excel.charting,
GH said:
I'm looking to create a floating bar chart separated into four quartiles to
plot some statistical data. For example, I'd be plotting the 5th percentile,
25th percentile, median, 75th percentile, and 95th percentile to separate the
bar into 4 sections. I would then overlay another data point that fits into
one of those sections. Any suggestions on how to do that?

Lay your data out like this:

5th 25th Median 75th 95th Other
A [5th] [25-5] [med-25] [75-med] [95-75] [other]
B [5th] [25-5] [med-25] [75-med] [95-75] [other]
C [5th] [25-5] [med-25] [75-med] [95-75] [other]

Create a stacked bar chart, format the first series ("5th") to have no
border and no area, so it's invisible. Then change the chart type of
"Other" to a Line chart and format it to have no line, only a symbol.

The key is to make each stacked rectangle be the *difference* between
two percentiles, so that stacking them gets you the total.

Use PERCENTILE() to find the statistics of your base data.

--
Del Cotter
NB Personal replies to this post will send email to ,
which goes to a spam folder-- please send your email to del3 instead.

Floating Bar with Quartile Ranks
 

That's not too different from this:

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

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


"GH" wrote in message
...
I'm looking to create a floating bar chart separated into four quartiles
to
plot some statistical data. For example, I'd be plotting the 5th
percentile,
25th percentile, median, 75th percentile, and 95th percentile to separate
the
bar into 4 sections. I would then overlay another data point that fits
into
one of those sections. Any suggestions on how to do that?