View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier[_2_] Jon Peltier[_2_] is offline
external usenet poster
 
Posts: 461
Default 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