d -

One approach is "jittering."

Use numerical values for both X and Y.

Then, for example, if the X values (with multiple Y values) are
1,1,1,2,2,..., instead use 0.95,1.00,1.05,1.95,2.00,...

- Mike Middleton
http://www.DecisionToolworks.com
Decision Analysis Add-ins for Excel


"d" wrote in message
...
I want to make an xy scatter chart. However the data is catagorical and
therefore a number of points are in exactly the same location and do not
show. I am looking for a function to stagger the points so it is possible
to
se how many there actually are, rather than just seeing one. Any ideas?
--
d