+ Reply to Thread
Results 1 to 4 of 4

How to make a graph start at the proper place?

  1. #1
    Registered User
    Join Date
    05-14-2009
    Location
    Argentina
    MS-Off Ver
    Excel 2003
    Posts
    4

    How to make a graph start at the proper place?

    Hi,
    I have a stupid table, it has two columns X and Y.
    X goes from 0 to 10.
    Y = 2*X+1
    I do the graph, and select for the Horizontal Axis Label the values of X.
    However, when I see the graph, the value for 0 is not over the Y Axis as I want it to be.
    How can I correct this?
    Here's an attachment with the example.
    TIA & Regards ...
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    06-09-2009
    Location
    Wales
    MS-Off Ver
    Excel 2003
    Posts
    155

    Re: How to make a graph start at the proper place?

    Once you have made the graph, right click on the scale (number) on the Y axis, click on format axis and then the scale tab. This will offer you a tick box which you can check and edit as to where you want the axis to cross. (i.e. 0)

    Good luck

    S

    ps. you can do the same by clicking on the numbers on the x axis in the same way.
    Last edited by opsman; 06-13-2009 at 10:12 PM.

  3. #3
    Registered User
    Join Date
    05-14-2009
    Location
    Argentina
    MS-Off Ver
    Excel 2003
    Posts
    4

    Re: How to make a graph start at the proper place?

    Tx, you pointed me int the proper direction.
    I've went to the horizontal axis, right clicked, and there selected "Position Axis" "On Tick Marks" instead of "Between tick marks".
    Now problem is solved, so thank you very much.

  4. #4
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,431

    Re: How to make a graph start at the proper place?

    Use xy-scatter chart type rather than Line.
    Cheers
    Andy
    www.andypope.info

+ 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