Manually set max axis value

[yaya123]

Hello,
I have a chart that have y-axis values normally between 0-50 but sometimes i get a peak with value 400 and then my chart becomes unclear because y-axis max value then goes up to 400.

Is it possible to set a roof here so max value on y-axis is e.g. 60 and values above that is visible as 60 then in the chart.

 

[VoG]

You might want to consider a broken axis AJP Excel Information - Broken Y axis and columns