+ Reply to Thread
Results 1 to 3 of 3

Scatter Plot doesn't plot data correctedly (values are numbers, not text)

  1. #1
    Registered User
    Join Date
    07-18-2012
    Location
    new york
    MS-Off Ver
    Excel 2007
    Posts
    2

    Scatter Plot doesn't plot data correctedly (values are numbers, not text)

    For some reason when I'm trying to plot data that have very small ranges, the dots in scatter plot do not line up correctly. for example a dot with x=4, y=4, plots on x=~4.2 and y = ~3.8 Once I introduced more variability (greater range of data), the scatter plot looks accurate.

    I checked to make sure all values are numbers using ISNUMBER function.

    Also originally Excel created y axis scale that looked like 0, 0, 1, 1, 2, 2, 3, 3...etc instead of 0, 1, 2, 3..etc

    I attached my spreadsheet. Any help would be greatly appreciated.

    thank you in advance for your time and assistance!
    Lisa
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    13,206

    Re: Scatter Plot doesn't plot data correctedly (values are numbers, not text)

    Are you certain the values of your sample point (x=4, y=4) are exactly 4.00000000 and 4.000000000? It looks to me like the values in question are just displayed to 0 decimal places, but the actual values are between 3.5 and 4.5.

  3. #3
    Registered User
    Join Date
    07-18-2012
    Location
    new york
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Scatter Plot doesn't plot data correctedly (values are numbers, not text)

    Thank you!!! I was helping a colleague and did not create the data. Since data were suppose to be integers, I incorrectly assumed that they were. But I should have still known better to check for decimal places. Lesson learned. Appreciated your quick response and assistance MrShorty.

+ 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