"Trendline Linear" Reference line 10% help

Anonymous · ‎2018-04-23

Hi,

What is the expression to create two linear trendlines +/- 10%?

X: AVG(Temp)

Y: Sum(kWh)

I want the chart to look like this:

sunny_talwar · ‎2018-04-23

May be use Linest function to create a linear line and multiple it with 1.10 and 0.90 to get the two other lines

Anonymous · ‎2018-04-23

Thanks for reply.

I have tried, but i dont understand how to use that function in my application...

Anonymous · ‎2018-04-23

Y: Sum(kWh)

X: AVG(Temp)

Dimension is week.