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 values, 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
Bookmarks