# Thread: Box and whiskers (2003)

1. ## Box and whiskers (2003)

I would like to create a graph which plots grades 1 through 6 as x-axis. The y-axis plots salaries (as a scatter graph) of staff members of these grades. However, I additionally want to add a box which surrounds these from a minimum to maximum salary within each grade. That is, several "stars" appear vertically and most staff members salaries would fall within the box.. I believe this might be called a box and whiskers graph?! Any clues? Thanks, Andy.

2. ## Re: Box and whiskers (2003)

Check out Jon Peltier's Box-Whisker for some ideas

Steve

3. ## Re: Box and whiskers (2003)

Thanks. The Box and Whisker is perhaps not the one I want - that only seems to show one value between a maximum and minimum value. Any other thoughts? Andy.

4. ## Re: Box and whiskers (2003)

Does the attached do what you want? The yellow boxes show the interval from the average minus 1 standard deviation to the average plus 1 standard deviation for each grade. If the salaries are more or less normally distributed, about two thirds of the salaries should fall within the box. (If you use 2 standard deviations instead of 1, about 95% should fall within the box).
The chart was created as an XY scatter chart based on the salary data, then the average-1SD and 2SD data were added, plotted on the secondary axis, and changed to a stacked column chart. The average-1SD series was made transparent. Finally, a bit of fiddling with the axes made everything fit together.

5. ## Re: Box and whiskers (2003)

Hans,
<img src=/S/whisper.gif border=0 alt=whisper width=29 height=17>I am not sure why you want to have separate Y-Axes for the 2 data sets since they should match up on the same scale. There is much less playing with the axes if you allow them to use the same Y axis

Steve

6. ## Re: Box and whiskers (2003)

You're correct - I thought I needed a secondary Y axis for the stacked column chart, but I only need a secondary X axis. Thanks!

Modified example attached.

7. ## Re: Box and whiskers (2003)

Don't know if this is any help at all but I built this graph from:
x= job evaluation score
y=current hourly rates
I've attached a picture of the graph showing the output

Jim

8. ## Re: Box and whiskers (2003)

Thank you very much everyone for the solution. Andy.

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•