Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Quartile and multiple if | Excel Discussion (Misc queries) | |||
Third Quartile (75th Percentile | Excel Discussion (Misc queries) | |||
Lookup to return count, median, lower quartile, upper quartile&ave | Excel Discussion (Misc queries) | |||
Condtional Quartile statement | Excel Worksheet Functions | |||
Quartile Function | Excel Discussion (Misc queries) |