title: Is it posible to get the position of point on an excel graph axis
body: <p>I'm not sure this is possible but thought this was the best place to ask.</p>
  
  <p>Is it posible to get the position of a series value on a graph in excel?</p>
  
  <p>For example,  if I have a line graph in excel that has time along the x axis, is it possible to (using VBA) get the position of a specific point on that axis.</p>
  
  <p>What I am trying to do is have a vertical line that is can be positioned based on a date entered by the user.</p>
  
  <p>like this</p>
  
  <p><img src="https://i.stack.imgur.com/n1G6U.jpg" alt="enter image description here"></p>
  
  <p>Where the green line could be positioned by entering in a date (rather than just being manually moved)  (or also it could be set to automatically move to the current date etc).</p>
  
  <p>I was then thinking that if the position is on the graph is queryable, then I can just access the line object and move it to any position I wanted through VBA.</p>
  
  <p>Any Ideas?  or is this just not possible? </p>