What I have at the moment:
Multiple worksheets in a workbook that contains data to be plotted on a chart.
The file is attached as an example. The source data is from rows 50-56.
I would like to have the secondary axis equal the value in cell AF132
I have attached an example of one worksheet. There are about 20 worksheets per workbook and about 15 workbooks.
I have already built some code that will build these tabs from a template so the formatting is not important. Plotting the data and changing the min/max scale is the need.
Also, if it is too much to accomplish based on the bottom chart.. Simply plot the data on the top chart.
Willing to pay if this is too much to handle for somebody...