Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old December 2nd 04, 02:41 AM
cshdabomb
 
Posts: n/a
Default 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.

  #2   Report Post  
Old December 2nd 04, 12:58 PM
Bernard V Liengme
 
Posts: n/a
Default

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.





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Trendline error??? Eugepticus Charts and Charting in Excel 3 November 30th 04 04:40 AM
Extending a Chart Data Series from an Array - Can it be done? Jon Peltier Charts and Charting in Excel 4 November 30th 04 03:30 AM


All times are GMT +1. The time now is 05:30 AM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017