+ Reply to Thread
Results 1 to 7 of 7

Altering x-coordinates on graph

  1. #1
    Registered User
    Join Date
    12-08-2008
    Location
    Utah
    Posts
    2

    Altering x-coordinates on graph

    In a graph that I have made [xy scatter: line], the x-coordinates that have been selected, as a row, start at 1672.5 and go to 1997.5. However, when I graph it the scale changes and starts at 1 and goes to 325, so instead of using the x-coordinates in the rows I gave it, it's starting it numerically.

    ie. what should be 1672.5, 10 is now 1, 10 and what should be 1997.5, 3 is now 325, 3.

    Does anyone know of a way to avoid this? Is it because I am selected x-coordinates as rows instead of individually?
    Thanks

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678
    Sounds like you have a line graph, and want a scatter (x-y) plot. Select the chart, do Chart > Chart type.
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Registered User
    Join Date
    12-08-2008
    Location
    Utah
    Posts
    2
    hmmmm....I have it as a xy scatter with lines, would it maybe be because I am selecting multiple rows for x and y values? It seems if I just select one row of x and y values it plots them as what it should be, but as soon as I hold Ctrl and click the other rows in the series it starts it off at 1 again.

  4. #4
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678
    Post the workbook.

  5. #5
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,430
    If any of the cells in the data source are Text the series will be treated as sequential values.
    Cheers
    Andy
    www.andypope.info

  6. #6
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678
    If any of the cells in the data source are Text the series will be treated as sequential values.
    Categories, values, or either, Andy?

  7. #7
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,430
    X values will cause the x axis to become sequential 1 to n points.

    Y values will be treated as zero.

    Try this, select A1:B10, enter the formula

    =ROW()*100

    create xy-scatter.

    Now change A10 to '1000 - which will change x axis

    change B10 to '1000 and the line will drop to zero.

+ 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