1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Solved: Excel scatter plot help needed

Discussion in 'Business Applications' started by quikrjf3, Feb 11, 2007.

Thread Status:
Not open for further replies.
  1. quikrjf3

    quikrjf3 Thread Starter

    Joined:
    Dec 29, 2006
    Messages:
    31
    I am making a scatter plot using excel and the plot contains two series of close to 2000 points each. The problem is that because the points are so close together, you cant distinguish between a point that is labeled as a triangle or a square, they are all just clumped together as one big blurred line. Is there any way to have the points connected by a line that can be labeled more clearly. I would print them in different colors but the project that this is for needs to be printed in black in white. Let me know if there is anything i can do about this. Thanks in advance.
     
  2. OBP

    OBP

    Joined:
    Mar 8, 2005
    Messages:
    19,895
    Can you change the Left Hand Scale so that the Points can move further apart on the paper?
    Is it printing in "Landscape" to maximise the use of the paper?
    you could try using a dot and a circle as the points, then the dots might appear inside the circles where the values are the same.
     
As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/543341

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice