Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old April 2nd 06, 02:48 AM posted to microsoft.public.excel.charting
James
 
Posts: n/a
Default Box-and-whisker chart (box plots)

I created a box plot graph in excel (2000) yesterday and still have the chart.
Today I have been trying to do it again using different data and can't work
out how I did it. These forums tell me that there is no boxplot function in
excel, but I successfully used it yesterday.
Trying to remember the steps I took yesterday, I think I pressed a button
that looked a bit like a sigma symbol.
Please help...

  #2   Report Post  
Old April 2nd 06, 06:15 PM posted to microsoft.public.excel.charting
Jon Peltier
 
Posts: n/a
Default Box-and-whisker chart (box plots)

Excel has no box plot feature, but it provides features which can be cobbled
together into a box plot, and here is how:

http://peltiertech.com/Excel/Charts/BoxWhiskerV.html
http://peltiertech.com/Excel/Charts/BoxWhiskerH.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services - Tutorials and Custom Solutions -
http://PeltierTech.com/
2006 Excel User Conference, 19-21 April, Atlantic City, NJ
http://peltiertech.com/Excel/ExcelUserConf06.html
_______


"James" wrote in message
...
I created a box plot graph in excel (2000) yesterday and still have the
chart.
Today I have been trying to do it again using different data and can't
work
out how I did it. These forums tell me that there is no boxplot function
in
excel, but I successfully used it yesterday.
Trying to remember the steps I took yesterday, I think I pressed a button
that looked a bit like a sigma symbol.
Please help...



  #3   Report Post  
Old April 3rd 06, 01:14 AM posted to microsoft.public.excel.charting
James
 
Posts: n/a
Default Box-and-whisker chart (box plots)

Thanks, but I've read this page and other similar pages on how to construct
your own boxplots previously.
In attempting to edit the boxplots I had constructed, it was shown that they
were made using sigmaplot 9. I'm not sure I understand this as I have never
downloaded anything from this company. I did have the MS Office 2000 Pro cd
in the computer when I used it though.

"Jon Peltier" wrote:

Excel has no box plot feature, but it provides features which can be cobbled
together into a box plot, and here is how:

http://peltiertech.com/Excel/Charts/BoxWhiskerV.html
http://peltiertech.com/Excel/Charts/BoxWhiskerH.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services - Tutorials and Custom Solutions -
http://PeltierTech.com/
2006 Excel User Conference, 19-21 April, Atlantic City, NJ
http://peltiertech.com/Excel/ExcelUserConf06.html
_______


"James" wrote in message
...
I created a box plot graph in excel (2000) yesterday and still have the
chart.
Today I have been trying to do it again using different data and can't
work
out how I did it. These forums tell me that there is no boxplot function
in
excel, but I successfully used it yesterday.
Trying to remember the steps I took yesterday, I think I pressed a button
that looked a bit like a sigma symbol.
Please help...






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



All times are GMT +1. The time now is 06:04 AM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017