xy scatterplot questions

[chip Smith]

ok i need help with an xy scatter plot graph...i inserted
the info into the cells, made the graph. no i nee to find
out where the graph crosses a particular y
intercept.....any suggestions? thanx

 

[dvt]

ok i need help with an xy scatter plot graph...i inserted
the info into the cells, made the graph. no i nee to find
out where the graph crosses a particular y
intercept.....any suggestions? thanx

1) use the INTERCEPT function in your spreadsheet if your data is linear..
2) Use Andy Pope's example from
http://www.andypope.info/charts/intersection.htm if your data is not
linear.