I am trying to create macro that adds several textboxes to a chart. I would
like to position the textboxes with xy coordinates. Another thing I would
like to do is use a midpoint range for the x coordinate. So if x was a date
range starting 01/01/2006 and ending 01/31/2006 I would want to use
01/15/2006 for the x coordinate. I am using names for the x , y. Here is a
quick example for adding text boxes, but I am stuck on positioning the box.
Thanks!!

With ActiveChart.TextBoxes.Add(340, 212, 257, 17)
.Select
.AutoSize = True
.Formula = "='characters'!$A$2"
End With