finding the value of a point on chart

G

Guest

I need to find a value on the line of a chart that I did for chemistry. It
isn't one of the points in my table of values. I have the x value, but need
to know the y value. Thanks in advance for anyone's help.
 
G

Guest

How about doing a linear regression of the line (assuming it's linear) and
calculating the value of Y from your known X. Use the LINEST function to
get you there.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Plot value at top of chart 1
Hide the decimal "." point in chart 0
Problem with xy scatter with dates 7
Why is the chart data wrong when I hover over it in Excel 2007? 4
Positioning x axis at bottom of chart with negative values 5
Placing an arrow on the series line in a line chart 5
How to embed expression in data labels on a chart 2
Display data points that are less than the chart trendline 2

Top