Achieving Range with a trendline

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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
 
Back
Top