Results 1 to 2 of 2

Setting an Automatic Minimum Y to something other than zero

Threaded View

  1. #1
    Registered User
    Join Date
    01-30-2015
    Location
    Washington DC
    MS-Off Ver
    2010
    Posts
    37

    Setting an Automatic Minimum Y to something other than zero

    I am building a regression tool where the input data could range from hundreds to millions. The tool produces several charts (like the one attached). As you can see, the lowest y-axis value is well above zero...creating a lot of white space and a fairly flat curve when I use the automatic settings.

    While I do know how to change the minimum manually, I'd really like for this chart to automatically set the minimum value of the y-axis (i.e. the x-intercept) slightly below the lowest y value so the curve flattens out towards the bottom of the chart. Essentially, I'm trying to set the x-intercept to the following formula:

    X INTERCEPT = SMALLEST Y - (LARGEST Y - SMALLEST Y)*0.1

    I've made this regression tool so that is can churn out reports quickly based only input data and I'm trying to eliminate the need for any manual formatting etc.

    Thanks in advance,
    Chris
    Attached Images Attached Images

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Setting A Daily Minimum Price
    By dharmon in forum Excel General
    Replies: 1
    Last Post: 12-08-2015, 01:48 AM
  2. Setting a minimum value after an =IF formula
    By paulv2012 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-19-2015, 06:57 PM
  3. [SOLVED] Dynamic setting of x axis minimum value
    By Knut Kvinnsland in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 07-07-2014, 09:50 AM
  4. setting a minimum value to a multiplication
    By idanwcd in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-13-2014, 05:24 PM
  5. Dynamic Setting for Chart Axis Minimum
    By life2539 in forum Excel General
    Replies: 1
    Last Post: 09-20-2011, 07:30 PM
  6. Setting Maximum & minimum values on a Sumif
    By Jonathan Mahoney in forum Excel General
    Replies: 0
    Last Post: 06-22-2011, 09:36 AM
  7. Rounding Numbers and setting a minimum value
    By gthemerc in forum Excel General
    Replies: 3
    Last Post: 07-30-2010, 01:54 PM

Tags for this Thread

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