+ Reply to Thread
Results 1 to 3 of 3

Preventing trendlines from creating a negative Y axis

  1. #1
    Registered User
    Join Date
    09-01-2011
    Location
    Austria
    MS-Off Ver
    Excel 2007
    Posts
    78

    Preventing trendlines from creating a negative Y axis

    I noticed that if I have data that trends downward a straight line trendline will suddenly create a negative vertical axis. But if my data is only positive, how would I prevent that negative vertical axis from appearing?

    yer.xlsx

  2. #2
    Valued Forum Contributor Blake 7's Avatar
    Join Date
    10-01-2010
    Location
    Bogota, Colombia
    MS-Off Ver
    Excel 2010 64 bit and Excel 2007,
    Posts
    1,377

    Re: Preventing trendlines from creating a negative Y axis

    double click the axis and FIX the min to 0
    Blake 7

    If your question has been answered, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.

    If any member's response has helped to solve your problem, please consider using the scales icon on the top right of their post to show your appreciation.

    http://failblog.org/

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

    Re: Preventing trendlines from creating a negative Y axis

    You would need to fix the minimum vertical scale value to zero
    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)

Similar Threads

  1. Creating a Stock Management System with unique ID's - preventing duplicate ID's
    By digital_singh in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-11-2013, 03:17 PM
  2. [SOLVED] Creating Linear Trendlines for Certain x ranges in a Graph
    By anonymous59 in forum Excel Charting & Pivots
    Replies: 9
    Last Post: 07-26-2012, 05:01 AM
  3. [SOLVED] VBA- X axis below axis (with negative values)
    By j.lancaster1 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-18-2012, 06:06 PM
  4. Need Help preventing columns from going negative.
    By rbpd5015 in forum Excel General
    Replies: 2
    Last Post: 12-10-2011, 08:47 PM
  5. Negative Numbers on my X axis...how to??
    By racinjason1978 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 04-30-2008, 10:31 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