+ Reply to Thread
Results 1 to 3 of 3

SOLVED-Dynamically change size/range of x axis of chart

  1. #1
    Registered User
    Join Date
    08-04-2017
    Location
    California
    MS-Off Ver
    2010
    Posts
    3

    Post SOLVED-Dynamically change size/range of x axis of chart

    Howdy !

    My first post on here, so let me know in the comments if I left anything out.

    I have attached a simplified version of my project which illustrates my problem of creating a chart, when the data dynamically changes quantity, the graph gets thrown off.

    You can see that if you change the subject in the drop down menu, the graph gets messed up because each subject has a different duration and therefor a differently structured x axis. My simple goal is just to have the graph display dose over time in a normal looking manner when you change from subject to subject.

    let me know if anyone can help with this!
    Attached Files Attached Files
    Last edited by helpme858; 08-07-2017 at 12:20 PM. Reason: Solved

  2. #2
    Valued Forum Contributor quekbc's Avatar
    Join Date
    01-18-2010
    Location
    Sydney, Australia
    MS-Off Ver
    2010, 2013, 2016
    Posts
    1,149

    Re: Dynamically change size/range of x axis of chart

    Since they the x-axis are dates, you can basically replace any outputs as empty strings "" into NA(). #N/As are not charted in charts, and if the x-axis does the same, it'll cut the chart min/max x-axis the same.

    Given how it's currently laid out, all you need to change is

    'Dynamic Subject Profile' cell C11:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    and copy it down

  3. #3
    Registered User
    Join Date
    08-04-2017
    Location
    California
    MS-Off Ver
    2010
    Posts
    3

    Re: Dynamically change size/range of x axis of chart

    Thanks so much that worked perfectly and such a simple fix ! Have a great day in Sydney

+ 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] how to change the axis label range of chart in excel vba
    By ImranBhatti in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-07-2017, 10:17 AM
  2. help with vba code to dynamically update the chart and its axis
    By rv02 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-03-2016, 06:08 AM
  3. Dynamically Change Marker Size and Background Colour for XY Scatter
    By MJU007 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 02-05-2016, 05:19 PM
  4. [SOLVED] Dynamically change X-axis as per dropdown selection
    By Sai Prashanth in forum Excel General
    Replies: 3
    Last Post: 09-12-2014, 05:20 PM
  5. [SOLVED] How to change axis font size for a bar chart
    By excelnoob61 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-07-2014, 03:15 PM
  6. Change the range in x axis dynamically for line chart
    By dimwit in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 06-27-2013, 05:23 AM
  7. Change size of Excel Data Table, dynamically
    By joshjpang in forum Excel General
    Replies: 10
    Last Post: 02-08-2013, 06:26 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