+ Reply to Thread
Results 1 to 7 of 7

How to make a line graph start at 100 not 0 on the Horizontal axis

  1. #1
    Registered User
    Join Date
    04-18-2012
    Location
    Norway, Ålesund
    MS-Off Ver
    Microsoft office 2010/2013
    Posts
    51

    Question How to make a line graph start at 100 not 0 on the Horizontal axis

    So I have searched for a long time without luck, and I went here for help
    So i would like to make a graph, but I want the Line Graph to start at 100 not 0. This is on the Horizontal axis.
    Example.png
    If you see the picture above, The graph starts at 100 and not 0 at the bottom (In the future I would like to be able to do it with both axis )

  2. #2
    Forum Expert
    Join Date
    12-15-2009
    Location
    Chicago, IL
    MS-Off Ver
    Microsoft Office 365
    Posts
    3,177

    Re: How to make a line graph start at 100 not 0 on the Horizontal axis

    Right click your mouse on the axis, click on format axis, then set your lower limit to 100

  3. #3
    Valued Forum Contributor
    Join Date
    05-08-2012
    Location
    Georgia, USA
    MS-Off Ver
    Excel 2003, 2010
    Posts
    811

    Re: How to make a line graph start at 100 not 0 on the Horizontal axis

    Position your mouse over the axis you want to change.

    Double click on the axis (either x or Y axis)

    You should get a dialog box that says Format Axis

    Go to the Scale Tab and change the minimum from 0 to 100 and click OK
    Click on star (*) below if this helps

  4. #4
    Registered User
    Join Date
    04-18-2012
    Location
    Norway, Ålesund
    MS-Off Ver
    Microsoft office 2010/2013
    Posts
    51

    Re: How to make a line graph start at 100 not 0 on the Horizontal axis

    But is there a way that i could have the 0, and let the graph start at 100? Would be quite nice!

  5. #5
    Valued Forum Contributor
    Join Date
    05-08-2012
    Location
    Georgia, USA
    MS-Off Ver
    Excel 2003, 2010
    Posts
    811

    Re: How to make a line graph start at 100 not 0 on the Horizontal axis

    You could manually delete the data values below 100

  6. #6
    Registered User
    Join Date
    04-18-2012
    Location
    Norway, Ålesund
    MS-Off Ver
    Microsoft office 2010/2013
    Posts
    51

    Re: How to make a line graph start at 100 not 0 on the Horizontal axis

    Hmm, after looking, I am satisfied!

  7. #7
    Valued Forum Contributor
    Join Date
    05-08-2012
    Location
    Georgia, USA
    MS-Off Ver
    Excel 2003, 2010
    Posts
    811

    Re: How to make a line graph start at 100 not 0 on the Horizontal axis

    Be sure to mark as [Solved].

    Click on the Star at the end of this message

+ 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