Microsoft Excel Tutorial
  Home FAQ Contact Sign in
 
 Advanced search
MATCHING GROUPS



more...
POPULAR GROUPS

more...
found 5943 articles for 1.027 sec
Hi Gaj - I took what you said as cordial, and was just trying to indicate that while such features as notches in a box plot might be useful and common in some disciplines, my experience did not include such features. I must need to adjust my medications, however, as a few times in the past month or so I've been accused of being defensive or offensive, and that is never my intention. I     

Group: microsoft.public.excel.charting · Group Profile · Search for Microsoft Excel Tutorial in microsoft.public.excel.charting
Author: Jon Peltier
Date: Jun 20, 2007 12:00

If we are introducing different visuals for the error of the median, why not retain the "familiar idiom" of the box chart, and merely add a visual to represent the error. This could be a line across the bar (like your red markers in either version of your chart) or some other type of marker. It avoids reinvention of the entire wheel. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials
Show full article (12.54Kb)
Duh, duh, exhibits ignored, personal defensive stance taken, while my aim was quite the opposite (I thought it was obvious, but apparently ...). Anyway, my point was and is that notched boxplots *ARE* used in "real display of information", "heat of the battle" or whatever one calls that -- at least every now and then. To add to the ignored exhibits (deliberately as diverse as I could find     

Group: microsoft.public.excel.charting · Group Profile · Search for Microsoft Excel Tutorial in microsoft.public.excel.charting
Author: Jon Peltier
Date: Jun 20, 2007 11:54

Gaj - I'm not an entomologist, nor have I read much on the anthropology of monkeys. I've worked in scientific research as a metallurgist (for my doctorate and a dozen years of employment following that), and as an engineer in manufacturing. Maybe not the widest mathematical background, and I'm not degreed in statistics (though I've taken a graduate level course or three). I've encountered
Show full article (1.53Kb)
Duh, every now and then even proved experts (even with a degree in statistics) say something that leaves me deeply perplexed. Less than five minutes of googling reveals these five fine examples: - Exhibit 1 (electronics / mobile phone manufacturing, 1996) http://ieeexplore.ieee.org/iel3/4031/12221/00561268.pdf?arnumber=561268 - Exhibit 2 (experimental / cognitive psychology, 1996) http     

Group: microsoft.public.excel.charting · Group Profile · Search for Microsoft Excel Tutorial in microsoft.public.excel.charting
Author: Gaj Vidmar
Date: Jun 19, 2007 11:12

Del - Your chart allows plenty of different quantities to be shown, but I suspect it may become cluttered, and at least for now, it's unfamiliar, and forces a lot of back and forth between the chart and the legend. Don't knock a "familiar idiom". The box plot is pretty much self-explanatory especially since it is familiar, and the difference between the box itself and the whiskers is
Show full article (10.36Kb)
From vrnpc#hotelmauro.it Thu Dec 14 08:09:50 2006 Return-Path: <vrnpc#hotelmauro.it> Envelope-To: xxxxxxxxxxx Delivery-Date: Thu, 14 Dec 2006 08:09:50 -0800 Received: from dslb-084-058-005-184.pools.arcor-ip.net ([84.58.5.184]) by localhost with smtp (Exim 4.50) id 1Gut9X-0007MN-6U for xxxxxxxxxxx; Thu, 14 Dec 2006 08:09:50 -0800 Received: (qmail 6837 invoked from network); Thu, 14 Dec     

Group: microsoft.public.excel.charting · Group Profile · Search for Microsoft Excel Tutorial in microsoft.public.excel.charting
Author: Jon Peltier
Date: Jun 19, 2007 09:36

If the data in the X range are not numeric (even if only one is not numeric), then Excel will treat the values as labels, and use the counting numbers 1, 2, 3, etc. as X values. If your blanks are "" returned by a formula, you should know that "" is a piece of text, not a blank, and is either treated as a zero or treated as a non-numeric X value. - Jon ------- Jon Peltier, Microsoft Excel
Show full article (5.82Kb)
Graphics and colors were redesigned in Office 2007, and there are a lot of changes compared to Excel 2003 and earlier. The old palette style colors aren't really supported, and the new themes look and behave differently. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Jon Dow" <JonDow@discussions     

Group: microsoft.public.excel.charting · Group Profile · Search for Microsoft Excel Tutorial in microsoft.public.excel.charting
Author: Gaj Vidmar
Date: Jun 19, 2007 07:17

A worksheet is the sheet with cells and rows and columns. Charts can be embedded on a worksheet. You hyperlink to one of these charts by actually hyperlinking to a cell under the chart, usually under the top left corner of the chart. A chart sheet, on the other hand, has no cells, no data other than the chart. You cannot create a hyperlink to a chart, but you can make a VBA link that mimics
Show full article (4.85Kb) · Show article thread
    

Group: microsoft.public.excel.charting · Group Profile · Search for Microsoft Excel Tutorial in microsoft.public.excel.charting
Author: Jon Peltier
Date: Jun 19, 2007 05:26

Show full article (2.64Kb)
    

Group: news.admin.net-abuse.sightings · Group Profile · Search for Microsoft Excel Tutorial in news.admin.net-abuse.sightings
Author: none_none1_invalid
Date: Dec 14, 2006 09:01

Show full article (11.01Kb)
    

Group: microsoft.public.excel.charting · Group Profile · Search for Microsoft Excel Tutorial in microsoft.public.excel.charting
Author: Jon Peltier
Date: Sep 22, 2008 21:58

Show full article (0.73Kb) · Show article thread
    

Group: microsoft.public.excel.misc · Group Profile · Search for Microsoft Excel Tutorial in microsoft.public.excel.misc
Author: Jon Peltier
Date: Sep 17, 2008 13:45

Show full article (0.93Kb) · Show article thread
    

Group: microsoft.public.excel.charting · Group Profile · Search for Microsoft Excel Tutorial in microsoft.public.excel.charting
Author: Jon Peltier
Date: Sep 17, 2008 13:40

Show full article (1.07Kb) · Show article thread
1 · 2 · 3 · 4 · 5 · 6 · 7 · 8 · 9 · next