Scale chart to the value of reference line

[retko1985]

Hello,

I have bar chart which maximum value of the bar is for example 500, but my reference line is for example 1000. Now the reference line will not appear in the graph, probably because its not near 500. How can I set the chart to scale to the value of reference line.

Thank you.

[sunny_talwar]

On the Axis tab you can use a static number or an expression to determine the static max for the chart

[vkish16161]

Just use the expression you're using on y - axis as reference line expression.