+ Reply to Thread
Results 1 to 3 of 3

How to set automatic axis

  1. #1
    Registered User
    Join Date
    08-26-2020
    Location
    Canada
    MS-Off Ver
    2016
    Posts
    9

    Question How to set automatic axis

    Hi guys,

    I have a horizontal bar chart named Project Date. This chart has Automatic y-axis with task names. How do I make it so the dates on the x-axis is also automatic? I want the auto date to range from A32- A123.
    Or I want to be able to select the bounds on y-axis as tasks and auto select bounds based on data for x-axis(dates)


    Thank you in advance!!
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,224

    Re: How to set automatic axis

    Excel does not have a built in way to link chart axis limits to cell values, so you would need to use VBA to write your own procedure that will do this. Two approaches that I see being used:
    https://peltiertech.com/link-excel-c...lues-in-cells/
    https://peltiertech.com/chart-udf-control-axis-scale/

    Choose the technique you like and adapt Peltier's code to your specific scenario. If/when you get stuck, let us know how we can help.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  3. #3
    Registered User
    Join Date
    08-26-2020
    Location
    Canada
    MS-Off Ver
    2016
    Posts
    9

    Re: How to set automatic axis

    Hi MrShorty,

    I tried the VBA but its just way too much for me... I'll just change the min and max bounds every week, it won't be a big deal.

    Thanks again!!

+ 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] Automatic & Logical Duration Axis Adjustments
    By meseleto in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 11-13-2019, 03:59 AM
  2. Replies: 1
    Last Post: 09-19-2017, 12:55 PM
  3. Automatic change in axis scale
    By Kat2000 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-26-2016, 06:02 PM
  4. [SOLVED] Automatic updating of a time x-axis.
    By RockHound in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 01-02-2014, 02:18 PM
  5. Changing automatic value of the y axis on a series of charts
    By Joeschmo5 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 06-08-2009, 08:19 AM
  6. [SOLVED] Automatic axis format
    By jos in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 02-10-2005, 07:06 AM
  7. [SOLVED] Automatic Change of X-axis
    By Jan in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 01-16-2005, 03:06 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