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/
_______

"sfdc" wrote in message
...