Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everbody,
I've been browsing through the questions about creating trendlines and find it difficult to implenment into my example.
Does someone have any idea on how I can add a trendline in the Bar_chart where the value should of the trendline is always 99% ?
If the data results drops below 99% it should be marked in red, if its 99% or higher it should be marked in green.
I've added a simple testfile so it's easyer to follow what I mean.
I hope anyone can help me please.
Kind regards,
Monique
Monuque,
If it is a fixed value (99%), what you need is not a trend line but a reference line. See Presentation tab. Define expression for your line as 0.99.
Regards,
Michael
Monuque,
If it is a fixed value (99%), what you need is not a trend line but a reference line. See Presentation tab. Define expression for your line as 0.99.
Regards,
Michael
do you mean reference line, like that?
Yes indeed
Massimo,
Can you tell me how you did that please? I've been there to try it but I'm stuck on how to create the expression for the trendline.
apply Michael answer to get a chart as my image
this is the reference line in my previous post image
Hello Michael,
I've found it but I notice that the trendline stays on the 100%, I would like it to be on the 99% value.
Because it so close to the 100% I tried to set the reference line on 0.90 and the trendline stayed on the 100%
So this is not exactly what I want Sorry
See attached.
If you make your chart large enough, it is easy to see that the line is below 99.94%. Not 100% for sure.
You are absolutly wright, thank u so much.