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

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

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

On Thu, 15 Mar 2007, in microsoft.public.excel.charting,
nadir said:
how can i find the relation between x & y in chart

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.

--
Del Cotter
NB Personal replies to this post will send email to ,
which goes to a spam folder-- please send your email to del3 instead.

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

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

"nadir" wrote in message
...
how can i find the relation between x & y in chart