D Del Cotter Mar 15, 2007 #2 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.
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 Mar 16, 2007 #3 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 - 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
