+ Reply to Thread
Results 1 to 2 of 2

How to change automatically the minimum bound of the vertical axis of a line chart

  1. #1
    Registered User
    Join Date
    03-28-2016
    Location
    Lisbon
    MS-Off Ver
    2013
    Posts
    2

    How to change automatically the minimum bound of the vertical axis of a line chart

    Hi,

    I have a macro that fills a column, cell by cell, with resulted values from a formula which integrates random values and are then converted into text, until a preset number of filled cells is reached. These figures are depicted in real time in a line chart and I would like to automatically change the minimum bound of the vertical axis and make it equal to the minimum value reached after a certain preset number of runs.
    I tried several ways to do it but I didnīt succeed.
    Would you please provide me a clue on how to do it?

    Many thanks in advance,

    Rui Assis

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    Excel 2013 (Win 10 - Work) & 365 Subscription (Win 10 - Home)
    Posts
    19,796

    Re: How to change automatically the minimum bound of the vertical axis of a line chart

    Welcome to the forum!

    Can you provide a sample workbook?
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!

    STOP PRESS: Forum Rules Updated September 2018! Please read them here.
    If anyone has helped you towards solving a problem, then you can thank them by clicking on their reputation star bottom left.

+ 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