Am I able to link a charts Axis bounds to a cell to set the max?

[bruty]

On a spreadsheet I have there are a number of bar charts that are linked to a drop down box to select the criteria which feeds it from my data source. All this is working fine, but the issue I have is that the different selections have a wide range of scores so if I just have 1 axis either some charts plot really small or are off the scale.

Is there a way to link the axis maximum bound to a cell where I calculate the max required?

 

[bruty]

Resolved this by looping through the charts with a macro and setting the axes that way.