Reference line Doubt

[#1]

I have a bar chart....where the expression I am showing is in %'s....the heighest  % is 40%.....I want a reference line at 56.5%.....Under refrence line % is not enabling.....how can I get reference line at 56.5%..........

[kji]

Percentile reference lines are only available in scatter charts, but to get a reference line at 56.5% you should set 0.565 as your expression.

[Gysbert_Wassenaar]

Increase the maximum of your scale to something higher than 40%. You can change this on the Axes tab by checking Static Max and filling in for example 0.6 (i.e. 60%)

[#4]

Johan...Thankyou....My expression is count() and I am using relative to show in %'s, So I assigned count()=0.565 I got a reference line in chart but its at 0 level......

Gysbert...Thankyou...I incresesd scale to 60% but I am not understanding how the expression for reference line should be....

[#5]

Ok..I got it...I just gave =.565 as expression its working.....