Dynamic Y Axis

[MikeJones]

Hi, how can I create a dynamic y axis which must show the KPI value £6 as per the reference line?

 I have created this chart with Appearance, Y axis, Range, Max 8.

Should a employee have a value above £8, the y axis does not increase.