Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
How do I get exact values from a graph in Excel?
Is it possible to get exact values from a graph that isn't one of your data
points? When I graph nonlinear variables is there some type of formula I can type in to get me an exact x value for a specific y value. For example i have x values of 0, 1, 2.5, 5, 10.... and y values of 100, 79, 55, 32, 12. If I want to know what x equals when y=50 how do i go about doing that? I know that I can't use the standard y=mx+b because my data is not linear... any suggestions?? I've been trying to figure it out for a couple of weeks and its starting to drive me crazy. Ive looked into a couple of other graphing programs (Igor Pro, GraphPad Prism and Delta Graph 3 and they have been no help either!) Thank you! |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
How do I get exact values from a graph in Excel?
Carolyne wrote on Tue, 11 Jul 2006 13:05:02 -0700:
C Is it possible to get exact values from a graph that isn't C one of your data points? When I graph nonlinear variables is C there some type of formula I can type in to get me an exact C x value for a specific y value. For example i have x values C of 0, 1, 2.5, 5, 10.... and y values of 100, 79, 55, 32, 12. C If I want to know what x equals when y=50 how do i go about C doing that? I know that I can't use the standard y=mx+b C because my data is not linear... any suggestions?? I've been C trying to figure it out for a couple of weeks and its C starting to drive me crazy. Ive looked into a couple of C other graphing programs (Igor Pro, GraphPad Prism and Delta C Graph 3 and they have been no help either!) Despite its name, FORECAST can be used to get points internal to a graph. James Silverton. |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
How do I get exact values from a graph in Excel?
If your data is noisy, then fitting a polynomial (as others suggested) can
smooth it before you average. However, if the data is not noisy and not from a low order polynomial, you should be aware that a least squares fit need not pass through any observed points. If you really want the value that the chart displays, then the chart smoother appears to fit Bezier curves http://www.xlrotor.com/Smooth_curve_...ample_file.zip which in most instances is not greatly different than cubic splines http://groups.google.com/group/micro...rogramming/msg... (local polynomial fits that do pass through the data points, as opposed to a global polynomial fit that may not). Jerry "Carolyne" wrote: Is it possible to get exact values from a graph that isn't one of your data points? When I graph nonlinear variables is there some type of formula I can type in to get me an exact x value for a specific y value. For example i have x values of 0, 1, 2.5, 5, 10.... and y values of 100, 79, 55, 32, 12. If I want to know what x equals when y=50 how do i go about doing that? I know that I can't use the standard y=mx+b because my data is not linear... any suggestions?? I've been trying to figure it out for a couple of weeks and its starting to drive me crazy. Ive looked into a couple of other graphing programs (Igor Pro, GraphPad Prism and Delta Graph 3 and they have been no help either!) Thank you! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Graph script | Charts and Charting in Excel | |||
Get excel to list values that occur within raw data | Excel Discussion (Misc queries) | |||
Can I grab graph coordinates in Excel via the mouse with VB? | Charts and Charting in Excel | |||
Excel graph linked to PPT | Excel Discussion (Misc queries) | |||
Copying an Excel Graph to PowerPoint | Charts and Charting in Excel |