Trendline

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

Guest

Hey!

I want to plot trendlines in a xy-chart, not just one. How can I plot
trendlines(linear) in the chart with different steps? Ex for x: 0-100,
100-200...I need the equation of the line of best fit for the different steps.

oks
 
oks or Trend -

Maybe you could use the several instances of the TREND array-entered
function in an adjacent column.

For example, for use one TREND in C1:C10 for the XY data in A1:B10, use
another TREND in C11:C20 for the XY data in A11:B20, etc.

Then use Chart | Source Data | Series to add the new fitted values to the XY
chart.

- Mike
www.mikemiddleton.com
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Can trendline equations be automatically entered into cells? 1
Setting intercept to zero with SLOPE/STEYX/etc 3
trendline - request power --> get linear 1
different color on scatter plot separated by a trendline 1
Sr. Citizen Question On Adding A Trendline, Please ? 1
Get value equal to final point of chart trendline [=Trend( )] ? 1
How would I attach or assign values to a trendline? 3
Trendline Showing Problem ? 2

Back
Top