+ 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
    Excel 2016
    Posts
    9,580

    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)

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