ExcelBanter - Achieving Range with a trendline

ExcelBanter (https://www.excelbanter.com/)

- Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)

- - Achieving Range with a trendline (https://www.excelbanter.com/charts-charting-excel/49-achieving-range-trendline.html)

cshdabomb

Achieving Range with a trendline

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

"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.

All times are GMT +1. The time now is 03:14 AM.