+ Reply to Thread
Results 1 to 2 of 2

Axis auto bounds goes to 0, how to set it up to the lowest number? (auto)

Hybrid View

  1. #1
    Forum Contributor
    Join Date
    06-20-2016
    Location
    Los Angeles/Thailand
    MS-Off Ver
    2016
    Posts
    250

    Axis auto bounds goes to 0, how to set it up to the lowest number? (auto)

    Hello, let's say I have 20 rides of cycling in the chart, I would like to have auto axes bounds set to the lowest ride, currently auto axes sets its self to 0 and I have to set it up manually. Is there anyway auto axes bounds can set it self to the lowest number of the chart?
    pic cycle.png
    Attached Files Attached Files

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

    Re: Axis auto bounds goes to 0, how to set it up to the lowest number? (auto)

    Options are Auto, where the chart decides based on data.
    Or manually to a specific value.

    In order to have the chart update the manually value based on data you will need to use VBA code to set the axis properties.
    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. [SOLVED] Auto Find Numbers & Auto Replacing Another number
    By TLRam1 in forum Excel General
    Replies: 17
    Last Post: 08-12-2015, 03:38 PM
  2. [SOLVED] VBA for changing the x-axis bounds in a graph
    By lrouquette in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-21-2015, 07:18 PM
  3. [SOLVED] Grid Reference - X and Y axis - Auto Selects value based on X and Y axis point
    By cruze2005 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-18-2014, 03:27 AM
  4. auto sort highest to lowest
    By B1G0 in forum Excel General
    Replies: 3
    Last Post: 04-02-2014, 05:37 PM
  5. Auto Sort Values From Highest To Lowest Based Off Of Value
    By CXP2 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-03-2011, 09:15 PM
  6. Auto sort values from highest to lowest based off of value
    By Vbort44 in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 07-09-2008, 07:21 PM
  7. [SOLVED] assign auto number and auto date
    By Krit Kasem in forum Excel General
    Replies: 3
    Last Post: 01-14-2005, 12:17 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