Dismiss Notice
Join Physics Forums Today!
The friendliest, high quality science and math community on the planet! Everyone who loves science is here!

Homework Help: Excel question

  1. Sep 12, 2010 #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 verticle line down to find the x value. How can i do this?
  2. jcsd
  3. Sep 12, 2010 #2


    User Avatar
    Gold Member

    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. Im not sure if there is a better way.
Share this great discussion with others via Reddit, Google+, Twitter, or Facebook