Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 1
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.charting
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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I change the color on scatter markers? Biostudent New Users to Excel 2 September 21st 08 03:32 AM
how to creat boxplot graph by Excel? Na Charts and Charting in Excel 2 July 23rd 08 01:16 PM
numbers as markers in XY scatter plot andrewworden Charts and Charting in Excel 0 January 30th 08 03:08 PM
How do I put markers on a scatter graph only for my labeled points Joan Weisenbloom Charts and Charting in Excel 2 January 9th 08 12:39 PM
XY Scatter Chart Markers Jane Charts and Charting in Excel 3 October 24th 07 09:07 PM


All times are GMT +1. The time now is 09:50 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"