percentile markers or boxplot on excel scatter graph
 

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

percentile markers or boxplot on excel scatter graph
 

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
Peltier Technical Services, Inc.
http://peltiertech.com/



Saroj wrote:
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