Estimating an X Value with a Known Y Value in Excel

  • Thread starter Thread starter 2slowtogofast
  • Start date Start date
  • Tags Tags
    Excel Value
Join the discussion
Ask a follow-up here, or get your own question answered by working scientists, mathematicians and engineers — people, not an autocomplete.
Real named experts · corrections over time · the nuance an AI answer skips
1 reply · 2K views
2slowtogofast
Messages
134
Reaction score
1
I have a graph in excel and i need to estimate an x value with a known y value. Pretty much i need to draw a horizontal line at y= given value over to my data line. Then a vertical line down to find the x value. How can i do this?
 
Physics news on Phys.org
Im not sure what version of excel you are using, but you could go "Insert >> Shapes" and then select the line and manually draw the lines and adjust as necessary. I am not sure if there is a better way.