ExcelBanter - find corresponding coordinates on graph

ExcelBanter (https://www.excelbanter.com/)

- Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)

- - find corresponding coordinates on graph (https://www.excelbanter.com/charts-charting-excel/224212-find-corresponding-coordinates-graph.html)

find corresponding coordinates on graph

Could someone please tell me how to find the corresponding coordinates on a
graph plotted in excel?. For example, If I have a graph and I am looking for
the value of y when x is 12, how would I go about this? Any help is greatly
appreciated

Dave Curtis[_2_]

find corresponding coordinates on graph

Hi,
Have you generated a trendline? Have you got the equation of the line?
From that you should be able to predict y from x.

Dave

"KJ" wrote:

Could someone please tell me how to find the corresponding coordinates on a
graph plotted in excel?. For example, If I have a graph and I am looking for
the value of y when x is 12, how would I go about this? Any help is greatly
appreciated

All times are GMT +1. The time now is 05:49 PM.