jkurtis
04-11-2016, 10:59 PM
I am trying to find a way to auto scale every chart in a worksheet based on each charts x and y axis min and max values.
I thought this was the solution to my problem on spreadsheetguru.com:
Google "vba-to-scale-every-excel-charts-y-axis-bounds"
But I can't get it to work. I have attached my excel spreadsheet. The charts are in the first sheet.
This solution seemed perfect because it is based on the charts values and not on cell values.
The data will change regularly so I hope the solution auto updates the scale for each chart.
I am not very good at VBA, so if someone can explain step by step how to do this, that would be amazing!
Cheers
Kurtis
I thought this was the solution to my problem on spreadsheetguru.com:
Google "vba-to-scale-every-excel-charts-y-axis-bounds"
But I can't get it to work. I have attached my excel spreadsheet. The charts are in the first sheet.
This solution seemed perfect because it is based on the charts values and not on cell values.
The data will change regularly so I hope the solution auto updates the scale for each chart.
I am not very good at VBA, so if someone can explain step by step how to do this, that would be amazing!
Cheers
Kurtis