+ Reply to Thread
Results 1 to 2 of 2

Auto Range y-axis.

  1. #1
    Registered User
    Join Date
    12-04-2019
    Location
    Tropical Australia
    MS-Off Ver
    Office 2019
    Posts
    39

    Auto Range y-axis.

    Hi, I have a chart that gets it's data from a data table. The X-axis automatically updates as data is added to the table, but I have to manually set the range for the y axis initially when I set up each chart. Appreciate any help.

  2. #2
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,316

    Re: Auto Range y-axis.

    The range should auto adjust also, but without seeing what you are working on it's hard to say what challenges you are facing.

    If you right click on the Y-Axis and select Format Axis, check to see if the Range Bounds are set to Auto.

    If not, maybe a sample workbook could help. Instructions in the "Yellow" banner at top to upload.
    HTH
    Regards, Jeff

+ 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. Axis auto bounds goes to 0, how to set it up to the lowest number? (auto)
    By sovietchild in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 05-09-2017, 03:20 AM
  2. [SOLVED] Chart X-Axis Range Automatically Expanding With Selected Y-Axis Range
    By Mvaldesi in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 10-08-2015, 03:43 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 Adjusting X Axis range based on dates
    By mcranda in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-24-2013, 06:05 PM
  5. Auto Y Axis based on the max cell value in a range
    By hskalsi in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 01-29-2012, 12:48 AM
  6. Replies: 0
    Last Post: 07-08-2011, 02:25 PM
  7. Excel Chart Axis Auto-Update based on cells with calculated range
    By jgray in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-29-2010, 03:50 PM

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