+ Reply to Thread
Results 1 to 2 of 2

Change the range in x axis dynamically for line chart

  1. #1
    Registered User
    Join Date
    05-27-2012
    Location
    Australia
    MS-Off Ver
    Excel 2010
    Posts
    5

    Change the range in x axis dynamically for line chart

    I am creating a chart that has xy scatter, area charts and error bars. x axis value initially started from 0 1 2 3 depending on days. The days are dependent on which day range users want to see. if User inputs start day 4 and end day as 10, I want the x axis to change the values to change. The values did change but the lines are 4 points away from (0,0). How or what do I need to do to align the line starting position with x axis?
    Region.png

    cheers
    DimWit
    Last edited by dimwit; 06-26-2013 at 10:43 PM. Reason: not line chart

  2. #2
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,375

    Re: Change the range in x axis dynamically for line chart

    Hello,

    You need to set the minimum of the X axis to the desired value. That can be done manually or automatically with a macro. If you post a file instead of an image, it would be a lot easier to provide help that you can use in your situation. You can attach a file if you click "Go Advanced" and then click the paper clip icon.

    cheers, teylyn

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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