ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   finding the value of a point on chart (https://www.excelbanter.com/charts-charting-excel/22616-finding-value-point-chart.html)

lifeguard_911

finding the value of a point on chart
 
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.



Barb R.

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.

"lifeguard_911" wrote:

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.




All times are GMT +1. The time now is 03:35 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com