Thread: How to get the corresponding X value for a given Y value?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
yahya yahya is offline
external usenet poster
  
Posts: 3
Default How to get the corresponding X value for a given Y value?
I have a chart in Excel 2007 and I want to provide a Y value (that is not one
of the data points) and have Excel to tell me the corresponding X value from
the chart. How can I do that?
The chart is not a straight line, so trendline won't work
Here is a picture of the chart I'm working on
http://hkoyda.blu.livefilestore.com/...x_wA/graph.JPG

Any help in this matter would be greatly appreciated.
Yahya

Reply With QuoteReply With Quote