View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
Carolyne Carolyne is offline
external usenet poster
 
Posts: 1
Default 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!