Data Points in Scatter Chart
 

Is there a way to offset data series in a scatter chart so that they do not
overlap each other?

Most probably, yes.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,
says...
Is there a way to offset data series in a scatter chart so that they do not
overlap each other?

I fudged a jitter type chart recently using the randbetween() function.
For X values between say 0 and 30, I added the following to the X value

RANDBETWEEN(-3,3)/20

You'll have to play with it to get what you want. Do a search for
RANDBETWEEN on the Microsoft Office Help screen for more information.

"Tushar Mehta" wrote in message
...
Most probably, yes.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,
says...
Is there a way to offset data series in a scatter chart so that they do
not
overlap each other?