Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
lifeguard_911
 
Posts: n/a
Default 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.


  #2   Report Post  
Barb R.
 
Posts: n/a
Default

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.


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Timeline Chart? ckrogers Charts and Charting in Excel 3 March 17th 05 09:20 PM
finding the coordinates of the maximum point on a graph eastham85 Charts and Charting in Excel 2 January 16th 05 01:34 PM
On a scatter chart show two point have same value Maz Page Charts and Charting in Excel 1 December 16th 04 01:00 PM
Import chart to Power Point and Macro problem Woody13 Excel Discussion (Misc queries) 1 December 8th 04 05:47 PM
pivot table multi line chart souris Charts and Charting in Excel 2 December 7th 04 03:56 AM


All times are GMT +1. The time now is 11:07 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"