Dynamic y axis on graphs

Hi Guys,

I am pulling a series of data to place into graphs.

I need these graphs to have the same y axis max value as each other, however the data varies so i need this to change when i change the input data.

I cannot use the excel Auto function as this will change the y axis to diferent values for each chart when they need to all show the same value.

I cannot set them as a fixed value because when I change the input data this value may be too high or low.

Any ideas on a solution?