+ Reply to Thread
Results 1 to 4 of 4

Data Points in Scatter Chart

  1. #1
    CWILSON
    Guest

    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?

  2. #2
    Tushar Mehta
    Guest

    Re: Data Points in Scatter Chart

    Most probably, yes.

    --
    Regards,

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

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


  3. #3
    Barb Reinhardt
    Guest

    Re: Data Points in Scatter Chart

    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" <[email protected]> wrote in message
    news:[email protected]...
    > Most probably, yes.
    >
    > --
    > Regards,
    >
    > Tushar Mehta
    > www.tushar-mehta.com
    > Excel, PowerPoint, and VBA add-ins, tutorials
    > Custom MS Office productivity solutions
    >
    > In article <[email protected]>,
    > [email protected] says...
    > > Is there a way to offset data series in a scatter chart so that they do

    not
    > > overlap each other?
    > >




  4. #4
    Jon Peltier
    Guest

    Re: Data Points in Scatter Chart

    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" <[email protected]> wrote in message
    > news:[email protected]...
    >
    >>Most probably, yes.
    >>
    >>--
    >>Regards,
    >>
    >>Tushar Mehta
    >>www.tushar-mehta.com
    >>Excel, PowerPoint, and VBA add-ins, tutorials
    >>Custom MS Office productivity solutions
    >>
    >>In article <[email protected]>,
    >>[email protected] says...
    >>
    >>>Is there a way to offset data series in a scatter chart so that they do

    >
    > not
    >
    >>>overlap each other?
    >>>

    >
    >
    >


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1