Set Chart Scale Min Max via Cell in worksheet

[MJSlattery]

I want to be able to control the vertical axis scale using values contained within my spreadsheet.

Can someone suggest a solution to this.

The only solutions I have found so far require VBA which is not my strong suite.

Thanks, Michael

[Andy Pope]

VBA is the only way.

http://www.excelforum.com/excel-char...worksheet.html