title: Attaching a Textbox to a point or line on a chart in Excel/VBA
body: <p>I was wondering how to attach a textbox to a point or line in an Excel chart for the macro I am working on. I have been using the <code>.AddTextbox</code> method such as </p>
  
  <pre><code>.Shapes.AddTextbox(msoTextOrientationHorizontal, 150, 250, 100, 15) _
        .TextFrame.Characters.Text = "Temperature"
  </code></pre>
  
  <p>But I have to then manually drag the textbox over the line on the chart it is representing as the orientation is of the chart not the line. Is there a way to convert the line/point to a chart orientation which I could use as a variable? or another way? Possibly using the datalabel function, though I want to be able to customize one of the axis locations. Thanks</p>