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
"cshdabomb" wrote in message
...
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.
|