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!

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.
Know someone interested in this topic? Share this thread via Reddit, Google+, Twitter, or Facebook

Similar Threads - Excel question Date
Solving for Minimum point Excel May 9, 2017
Euler's Method Tutorial Nov 21, 2015
Graphing stress-strain plots on excel Oct 31, 2015
Basic calcs in excel for dc lap wound motor Oct 5, 2015
EVEN EASIER EXCEL question Oct 31, 2008