Reply
 
LinkBack Thread Tools Display Modes
  #1   Report Post  
Old December 27th 06, 01:24 PM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Dec 2006
Posts: 2
Default How can you create Box Plots (Box-and-Whisker Plots) in Excel?

I would like to create side-by-side Box-and-Whisker Plots for exploratory
data analysis, comparing populations from a variety of sources (monitoring
wells, in this case). I want each "box" to include the following: a line at
the mean and a symbol at the median, a box extending to the first and third
quartiles, and whiskers extending to the min and max. I can tweak the details
myself, but I'm not sure how to get started with it, using the chart tools in
Excel.
Thanks for your help! - Amy

  #2   Report Post  
Old December 27th 06, 03:28 PM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 4,393
Default How can you create Box Plots (Box-and-Whisker Plots) in Excel?

Start he http://peltiertech.com/Excel/Charts/BoxWhisker.html
Happy new year
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Amy Bass" wrote in message
...
I would like to create side-by-side Box-and-Whisker Plots for exploratory
data analysis, comparing populations from a variety of sources (monitoring
wells, in this case). I want each "box" to include the following: a line
at
the mean and a symbol at the median, a box extending to the first and
third
quartiles, and whiskers extending to the min and max. I can tweak the
details
myself, but I'm not sure how to get started with it, using the chart tools
in
Excel.
Thanks for your help! - Amy



  #3   Report Post  
Old December 27th 06, 04:28 PM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Dec 2006
Posts: 2
Default How can you create Box Plots (Box-and-Whisker Plots) in Excel?

Thank you!

"Bernard Liengme" wrote:

Start he http://peltiertech.com/Excel/Charts/BoxWhisker.html
Happy new year
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Amy Bass" wrote in message
...
I would like to create side-by-side Box-and-Whisker Plots for exploratory
data analysis, comparing populations from a variety of sources (monitoring
wells, in this case). I want each "box" to include the following: a line
at
the mean and a symbol at the median, a box extending to the first and
third
quartiles, and whiskers extending to the min and max. I can tweak the
details
myself, but I'm not sure how to get started with it, using the chart tools
in
Excel.
Thanks for your help! - Amy




  #4   Report Post  
Old December 28th 06, 12:18 AM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 560
Default How can you create Box Plots (Box-and-Whisker Plots) in Excel?

On Wed, 27 Dec 2006, in microsoft.public.excel.charting,
Amy Bass said:
I would like to create side-by-side Box-and-Whisker Plots for exploratory
data analysis, comparing populations from a variety of sources (monitoring
wells, in this case). I want each "box" to include the following: a line at
the mean and a symbol at the median, a box extending to the first and third
quartiles, and whiskers extending to the min and max. I can tweak the details
myself, but I'm not sure how to get started with it, using the chart tools in
Excel.


There are various clever ways to create the full visual effect of the
classic John Tukey box-and-whisker plot using a combination chart of
line and stacked bar series, and doubtless a couple of posters will be
along shortly to show how that's done.

But may I suggest my preferred version that does the same job using only
Excel line chart series, without boxes, which are after all only a
visual aid invented in the days when draftsmen drew them with pen and
ruler?

http://www.branta.demon.co.uk/excel/...thoutboxes.xls

--
Del Cotter
NB Personal replies to this post will send email to ,
which goes to a spam folder-- please send your email to del3 instead.


Reply
Thread Tools
Display Modes

Posting Rules

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



All times are GMT +1. The time now is 11:59 AM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017