+ Reply to Thread
Results 1 to 3 of 3

overlapped points in X-Y scatter chart

  1. #1
    Registered User
    Join Date
    01-03-2011
    Location
    earth
    MS-Off Ver
    2010
    Posts
    35

    overlapped points in X-Y scatter chart

    Hi
    I have plotted a X-Y scatter chart. Problem is in some points, the markers are overlapped on each other.
    For example Series 1 have
    X = 10, Y = 20

    And also Series 2 have
    X = 10, Y = 20

    As a result the square and rectangle are overlapped. Is there any way to seperate them a few?

  2. #2
    Forum Expert Crooza's Avatar
    Join Date
    10-19-2013
    Location
    Hunter Valley, Australia
    MS-Off Ver
    Excel 2003 /7/10
    Posts
    2,082

    Re: overlapped points in X-Y scatter chart

    Wouldn't moving them defeat the purpose of an XY scatter chart? Are you better to change the symbols from solid filled to outline with no fill and maybe make one series larger than the other so you can see both. Maybe an open (unfilled) circle larger than the default setting and the other series a smaller symbol that could be seen inside the larger circle.

  3. #3
    Registered User
    Join Date
    01-03-2011
    Location
    earth
    MS-Off Ver
    2010
    Posts
    35

    Re: overlapped points in X-Y scatter chart

    Thanks. "No fill" is a handy solution.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Attach Labels to points in Scatter chart
    By Roop in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-15-2016, 04:45 AM
  2. How to graphically select a subset of points on an XY Scatter Chart?
    By geophysicist in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-20-2013, 12:29 AM
  3. labeling data points on a scatter chart
    By Mr Tee in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 03-31-2006, 08:20 AM
  4. Scatter chart with columns instead of points
    By Bill_S in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 10-07-2005, 12:05 AM
  5. [SOLVED] Data Points in Scatter Chart
    By CWILSON in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 01-26-2005, 10:07 PM

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