G
Guest
Is there a way to offset data series in a scatter chart so that they do not
overlap each other?
overlap each other?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
T
Tushar Mehta
Most probably, yes.
--
Regards,
Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
--
Regards,
Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
B
Barb Reinhardt
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.
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.
J
Jon Peltier
There are any number of variations. I've offset each series by a
different amount, so series 1 might be at X-0.1 and series 5 at X+0.1,
and the other distributed between them. On some projects, where we were
looking at points at different levels, I've kept the first at a value
right on, and each additional one I've offset by ±0.05 more than the
previous, so you get a sense for how many points are at each level: the
spread is proportional to the number of points. Barb's approach assigns
a random offset, so you might get some pairs of points right on top of
each other, and other pairs widely separated.
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
different amount, so series 1 might be at X-0.1 and series 5 at X+0.1,
and the other distributed between them. On some projects, where we were
looking at points at different levels, I've kept the first at a value
right on, and each additional one I've offset by ±0.05 more than the
previous, so you get a sense for how many points are at each level: the
spread is proportional to the number of points. Barb's approach assigns
a random offset, so you might get some pairs of points right on top of
each other, and other pairs widely separated.
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______