Change axis bounds in Excel based on data

[tetschlagk]

I am creating many line graphs and would like to know of a way to change the vertical axis bound minimum and maximum based on the data itself? For example for set of data, the amounts ranges from 6 million to 12 million while another data set ranges from 3 thousand to 5 thousand. Same graph just different data set. Is there a way to change these min and max automatically instead of entering in each time?

 

[ParamRay]

leave scale as automatic

 

[tetschlagk]

leave scale as automatic

I tried that and it isn't working. I am not sure what I am doing wrong. I have Auto selected on Minimum and Maximum Bounds as well as Major/Minor Units.