how can i find the relation between x & y in chart

D

Del Cotter

how can i find the relation between x & y in chart
Click to expand...

Don't. Find the relation between x and y in the spreadsheet cells
instead. Try the SLOPE() and INTERCEPT() functions, and read the help
files on the other functions available.
 
M

Mike Middleton

nadir -

Use an XY (Scatter) chart type, not a Line chart type.

Click once on a data point to select the data series. Choose Chart | Add
Trendline, and select an appropriate linear or nonlinear relationship.

- Mike
http://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

Sorting and filtering text 0
Non Linear Scatter plot, need to find y value 3
Filtered view of Visio Chart 0
Circular Bar chart? 4
Chart size relative to contents 1
simple chart 0
Scatter chart with categories on x-Axis 2
Automatic Way to have Equal Scales on X-Y Plots ? 0

Top