X axis scatter dot-plot

[govaerts_marc]

Is there some way or an add-in in Excel 2000 to create a
scatter dot-plot (X axis=categories, Y axis= numbers)
where dots with the same Y value would not overlap (by
moving overlapped dots along the X axis within each
category)(eventually along with a box-whisker plot) ?

 

[Jon Peltier]

There are a few tricks involved here. First, you need a way to offset
the points depending on how many share the same Y value, and which one
of those the current point is. This usually entails a helper column with
the offset calculations.

The second trick is that a category axis is incompatible with the
ability to offset points in this manner. But you could combine a Scatter
chart (for your markers) with a line chart (or other chart that uses a
category axis). Your X values would be the integer number of the
category (count them, 1-2-3...) plus or minus the offset. Alternatively,
you could use a dummy series along the X axis with data labels serving
as the category labels, as in this example:

http://peltiertech.com/Excel/Charts/ArbitraryAxis.html

I know I've worked out such examples in these newsgroups in the past.
You could search the archives at

http://www.google.com/advanced_group_search

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______