calculating an x value on a graph in excel?

Question

ive drawn a scatter plot graph and this contains my known values for x and for y . my problem is i have a value for y and it plots on the graph but i can't seem to find how to calculate its x value. i'm using excel. any help'd be great !!

my graph is for results from a uv vis scan

Answer 1

you should be able to just hold your cursor over the dot that your interested in and automatically a yellow box will pop up with the coordinates in it

.

Answer 2

You can add a trend line to your chart and display its equation. This will give you a transfer function of your plotted data which will allow you to compute a value of Y for any value of X

To add a trend line click on your series plot on the chart to select it then Right click and select trend line.Select the trend line type for a best fit and on the options tab check display equation on chart.

You can also do as was suggested an use your mouse to hover over the data point in the chart but if you have a lot of closely spaced data it can be difficult to distinguish between points.

If you know the value you can do a search of the data on the worksheet using FIND (CTRL+F) to locate the data points.

Answer 3

you ought to upload a fashion line on your chart and exhibit its equation. this promises you with a bypass function of your plotted records that can assist you compute a cost of Y for any fee of X to function a fashion line click on your sequence plot on the chart to pass with it then ideal click and choose sort line.pass with the rage line sort for a suitable in stable condition and on the innovations tab be certain exhibit equation on chart. you additionally can do as replaced into suggested an use your mouse to hover over the information component indoors the chart yet as quickly as you have multiple heavily spaced records this is complicated to tell apart between factors. in case you recognize the fee you're able to do a glance for of the information on the worksheet utilising come across (CTRL+F) to discover the information factors.