LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #10   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 64
Default How to get the corresponding X value for a given Y value?

wrote in message
http://help.lockergnome.com/office/d...ct1005590.html
Hey this really works! I sincerely appreciate the hand-holding youve
offered me here. I have been trying to figure out a good way to do this for
some time and I think your method will work very nicely for me. Thank you!


Glad it worked for you - don't know why these replies are dropping out?

I spent a long while figuring this out too. I'd initially been using goal
seek
with a parameter value but then realised you could make use of the IRR
function to solve the cubic eqn. It seemed to work in my test scenarios.




 
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



All times are GMT +1. The time now is 04:50 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"