Data Points in Scatter Chart

#1 01-25-2005, 01:06 PM

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

#2 01-25-2005, 01:06 PM

Most probably, yes.

--
Regards,

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

In article <CBBA4466-ECFA-42EB-A211-F60CA2DCB800@microsoft.com>,
CWILSON@discussions.microsoft.com says...
> Is there a way to offset data series in a scatter chart so that they do not
> overlap each other?
>

#3 01-25-2005, 01:06 PM

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" <tmUnderscore200310@tushar-mehta.SeeOhEm> wrote in message
news:MPG.1c603d3bd7ae4e48989a63@news-server.rochester.rr.com...
> Most probably, yes.
>
> --
> Regards,
>
> Tushar Mehta
> www.tushar-mehta.com
> Excel, PowerPoint, and VBA add-ins, tutorials
> Custom MS Office productivity solutions
>
> In article <CBBA4466-ECFA-42EB-A211-F60CA2DCB800@microsoft.com>,
> CWILSON@discussions.microsoft.com says...
> > Is there a way to offset data series in a scatter chart so that they do
not
> > overlap each other?
> >

#4 01-26-2005, 10:07 PM

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

Barb Reinhardt wrote:

> 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" <tmUnderscore200310@tushar-mehta.SeeOhEm> wrote in message
> news:MPG.1c603d3bd7ae4e48989a63@news-server.rochester.rr.com...
>
>>Most probably, yes.
>>
>>--
>>Regards,
>>
>>Tushar Mehta
>>www.tushar-mehta.com
>>Excel, PowerPoint, and VBA add-ins, tutorials
>>Custom MS Office productivity solutions
>>
>>In article <CBBA4466-ECFA-42EB-A211-F60CA2DCB800@microsoft.com>,
>>CWILSON@discussions.microsoft.com says...
>>
>>>Is there a way to offset data series in a scatter chart so that they do
>
> not
>
>>>overlap each other?
>>>
>
>
>

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)