Here's a function that I use.
Default is +- 0.1

Function Noise(Optional P = 0.1) As Double
'// P is a Peak value, such as +- 0.1
Noise = (Rnd() - 0.5) * P
End Function

--
HTH :)
Dana DeLouis
Windows XP & Office 2003


"Augabog" wrote in message
oups.com...
I am doing a scatterplot where a bunch of data points fall into the
exact same values. I would like to spread them out a little bit w/o
falling into the next bin, just to show that they are all there. Is
there any way in Excel to add some random noise to my data so that I
can stochastically automate this process?

Thanks,

Hosley