percentile markers or boxplot on excel scatter graph

[Saroj]

Hi everyone,

I am trying to create percentile markers next to each group on a scatter
graph. The percentile markers are 5th, 25th, 50th, 75th and 95th. The markers
should be in the shape of a boxplot. There are 4 groups and the markers
should be next to each group. I tried using the drawing tool (in microsoft
word) to do this but it was difficult to get the lines in the correct
position.

I'm using Microsoft excel 2003.

Thanks in advance,
Saroj

 

[Jon Peltier]

This page has links to some tutorials, and to a box and whisker chart
utility:

Box and Whisker Plots
http://peltiertech.com/Excel/Charts/BoxWhisker.html

- Jon

 

[Jon_Peltier]

I know this is an old thread, but people still follow the link to my web site.

I've updated the Box and Whisker Chart (Box Plot) article, and it's now named Excel Box and Whisker Diagrams (Box Plots).