On Mon, 9 Apr 2007, in microsoft.public.excel.charting,
KieranMoran said:
I have a scatter graph with a number of points that over lap. How do I show
them so that the reader can tell there are multiple points.

a) "Jittering", which is the name for putting a small random variation
in the data to break up the exact values. Obviously you want it to be as
small as possible while still exposing the hidden points

b) a non-random variation, moving the hidden points exactly and
systematically away from the first point and each other. This can create
a pattern that lets you show the first point as the one which is on the
right spot

c) A different symbol for multiple points, 1, 2, 3 etc., with a legend
to explain what the points mean

d) a bubble graph, with the bubbles proportional in area to the number
of overlapping points

--
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.