LinkBack Thread Tools Search this Thread Display Modes
  #21   Report Post  
Old June 21st 07, 10:27 PM posted to microsoft.public.excel.charting
external usenet poster
First recorded activity by ExcelBanter: Jul 2006
Posts: 6,582
Default Creating notches in box whisker plots in Microsoft Excel

Nope, I have not ever tried to generate notched box plots. There is no easy
way in an Excel chart to integrate a non-rectangular shape into the chart
series. I will give it further thought, of course, since other people find
it a more important feature than I thought it was.

If you want to show outliers as individual points outside the span of the
whiskers, stay tuned, because an unreleased version of the utility can
handle this.

- Jon
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. -

wrote in message
On Jun 19, 8:26 am, "Jon Peltier"
Del -

Yourchartallows 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 thechartand the legend. Don't knock a
"familiar idiom".

Theboxplot is pretty much self-explanatory especially since it is
familiar, and the difference between theboxitself and the whiskers is
immediately recognizable (compared to your multiple error bars colored
different shades of gray, which is slower to be interpreted). If you
make whiskers of various line lengths, that might help.

I agree that the notchedboxplot must be rather obscure, as I've never
it used in any real display of information.

- Jon
Jon Peltier,MicrosoftExcelMVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. -

"Del Cotter" wrote in message


On Fri, 15 Jun 2007, inmicrosoft.public.excel.charting,
Andy Pope said:
The technique describes how to use an xy-scatter to construct the

You need to add a few more xy pairs in order to reduce the width of
the Median line and form the notches.

While I have as much reverence for the late John Tukey as the next
person, I don't see that boxes and whiskers as such are necessary these
days, except that they're a familiar idiom that the graph viewer will
usually recognise.

And even that isn't true for notched boxes, which I don't think many
people have seen. Certainly most couldn't interpret without them a
guide; I never even knew until reading that article just now what the
notches were supposed to represent-- I thought they were just meant to
enphasise the median in some way.

If we abandon the need to copy Tukey's shapes, doing this stuff inExcel
immediately gets a lot easier. Here's my idea of a boxless "box" and
whiskerdistributionchart, with circled outliers and an error range
around the median, all just using the standardExcelsymbol shapes.

It would be simple to substitute circles, diamonds, or half-ticks, and
alter the thickness or colour of theExcelerror bars, to suit your
preferences, and I think the point comes across even though they're not
the traditional boxes.

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.- Hide quoted text -

- Show quoted text -

Wow!! I did not know my initial request generated such an exchange of
academic and technical passion. Just to let you know, I have decided
that if I need to generate a significant number of notched box whisker
charts, I am going to obtain the latest version of SigmaPlot (v 10
being the latest version) in order to generate them.

Jon, if your add-in can generate notched box whisker plots to the
scope and degree that SigmaPlot can, please let me know!!!


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
Creating notches in box whisker plots in Microsoft Excel [email protected] Excel Discussion (Misc queries) 1 June 17th 07 08:55 PM
Creating notches in box whisker plots [email protected] Excel Discussion (Misc queries) 0 June 14th 07 07:20 PM
How can you create Box Plots (Box-and-Whisker Plots) in Excel? Amy Bass Charts and Charting in Excel 3 December 28th 06 01:18 AM
Box-and-whisker chart (box plots) James Charts and Charting in Excel 2 April 3rd 06 01:14 AM
how do I create box and whisker plots in Excel? Gary Greeno Charts and Charting in Excel 2 November 10th 05 08:22 AM

All times are GMT +1. The time now is 12:01 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