+ Reply to Thread
Results 1 to 5 of 5
  1. 09-01-2009, 12:16 PM #1
    vanao
    vanao is offline
    Registered User
    Join Date
    09-01-2009
    Location
    Europe
    MS-Off Ver
    Excel 2007
    Posts
    3

    graphing: insert vertical line at zero-point

    Hi, I want this:
    http://img84.imageshack.us/img84/936...yfunction1.jpg
    to look like this:
    http://img228.imageshack.us/img228/3...yfunction2.jpg
    possible?
    Reply With Quote Reply With Quote
  2. 09-01-2009, 12:21 PM #2
    shg
    shg is online now
    Forum Moderator shg's Avatar
    Join Date
    06-21-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2007
    Posts
    25,137

    Re: graphing: insert vertical line at zero-point

    Add another series with two points.
    Microsoft MVP - Excel
    Entia non sunt multiplicanda sine necessitate
    Reply With Quote Reply With Quote
  3. 09-01-2009, 01:12 PM #3
    vanao
    vanao is offline
    Registered User
    Join Date
    09-01-2009
    Location
    Europe
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: graphing: insert vertical line at zero-point

    I see what you mean, but idk how to materalize that. I tried and attached the result. Any hints?
    Attached Files Attached Files
    Reply With Quote Reply With Quote
  4. 09-01-2009, 01:24 PM #4
    Andy Pope
    Andy Pope is offline
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    2003 & 2007 & 2010
    Posts
    10,944

    Re: graphing: insert vertical line at zero-point

    If you use a xy-scatter rather than a line then you can set the X axis to cross at 0.
    Attached Files Attached Files
    Cheers
    Andy
    www.andypope.info
    Reply With Quote Reply With Quote
  5. 09-01-2009, 03:38 PM #5
    vanao
    vanao is offline
    Registered User
    Join Date
    09-01-2009
    Location
    Europe
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: graphing: insert vertical line at zero-point

    very nice. ty.
    Reply With Quote Reply With Quote
« Previous Thread | Next 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.2.0