1. Limited time only! Sign up for a free 30min personal tutor trial with Chegg Tutors
    Dismiss Notice
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