Excel plots the data you give it. If two points have the same X and Y
values, they will be plotted in the same location in the chart. If you want
the points not to obscure each other, you need to offset them slightly.
Excel has no built-in functionality to generate this offset, so you'll have
to work out your own algorithm and write your own formulas.
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions http://PeltierTech.com/
_______
In Excel, one (tedious) way is to sort the XY pairs on the worksheet,
identify the duplicates, and for each duplicate pair add or subtract a small
number for either the X or Y value. It's a manual method for what's
sometimes called "jittering."
