Achieving Range with a trendline

[Guest]

I need help on figuring out how to display a range with error bars and a
trendline. Basically I need a trendline to go through the top half of the
error bars and the bottom half so that i can get a range.

 

[Bernard V Liengme]

Use the TREND function adding and subtracting errors

X Y Y(calc) Y +err
1 1.2 =trend(B2:B20,A2:A20) =C2+0.2
etc

best wishes
Bernard