View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default 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?