+ Reply to Thread
Results 1 to 3 of 3

XY scatter plot using wrong values

  1. #1
    Registered User
    Join Date
    03-04-2015
    Location
    Switzerland
    MS-Off Ver
    365
    Posts
    92

    XY scatter plot using wrong values

    Hi, I'm having some trouble getting excel to show the right values in a graph I'm trying to make.
    When I plot values in an XY scatter plot between 1 to 10, excel decides to make the X axis 1-Column number. For example - when the value on the x axis is 9: graph shows 1 (which is 10-1)
    I tried to format the axis - but this is not helping.

    I have done many excel xy scatter plot, but never got something like that. Any idea what to do?

    Thanks in advance
    SwissExcel

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

    Re: XY scatter plot using wrong values

    It is difficult to say without being able to see your chart/sheet.

    I see two common problems that may cause similar behavior:
    1) Check that all numbers are really numbers and not numbers stored as text and that there is not some other text string (an empty string "" from an error formula, maybe). When Excel encounters a text string (including a number stored as text) anywhere in the X values range, it uses count numbers (1,2,3,...) for the X values instead of the values in the X values range. The ISTEXT() function may be useful in testing if this scenario exists.
    2) Excel frequently guesses wrong at my desired X and Y values ranges when I create scatter charts. (The example here is for a line chart, but it illustrates the kind of garbage Excel sometimes gives me at chart creation: https://www.excelforum.com/excel-cha...ml#post4735253 ). In these cases, I go into the Select Data dialog and make sure that Excel is using the correct ranges/values for the X and Y values of each series.

    If neither of those helps, then I think we will need you to upload a sample file illustrating the issue.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  3. #3
    Registered User
    Join Date
    03-04-2015
    Location
    Switzerland
    MS-Off Ver
    365
    Posts
    92

    Re: XY scatter plot using wrong values

    Thank you Mrshorty !
    an empty string "" from an error formula... this was the problem.. not sure why Excel does it, but all seems to work afterwards
    cheers

+ 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. Scatter Plot X Axis & Trendline Formula Wrong
    By mhroberts in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 09-29-2015, 02:04 PM
  2. Scatter Plot Missing Values
    By jbm417 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 08-16-2015, 06:31 PM
  3. Replies: 2
    Last Post: 07-26-2012, 09:27 AM
  4. Replies: 3
    Last Post: 06-20-2012, 03:28 AM
  5. Scatter Plot with consistent X values
    By samineru in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 04-27-2012, 04:05 PM
  6. Scatter Plot with Two Sets of Y Values ???
    By malcolm347 in forum Excel General
    Replies: 1
    Last Post: 02-05-2009, 12:44 AM
  7. Wrong Interpretation of Excel Value - Scatter Plot Problem
    By Klaus Kragelund in forum Excel General
    Replies: 4
    Last Post: 02-18-2005, 10:06 AM

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