Adding Trendline with value 99%

[amber2000]

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

[Anonymous · Accepted solution]

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

[maxgro]

do you mean reference line, like that?

[amber2000]

Yes indeed

[amber2000]

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.

[maxgro]

apply Michael answer to get a chart as my image

[maxgro]

this is the reference line in my previous post image

[amber2000]

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

[Anonymous]

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.

[amber2000]

You are absolutly wright, thank u so much.