View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
Mona
 
Posts: n/a
Default textbox position

I am adding textboxes to a line chart. Is there anyway to add a textbox
(VBA?) using my chart xy coordinates?

01/02/2006 300
01/03/2006 400
01/05/2006 900
01/06/2006 300
01/07/2006 350

I would like to center a textbox at (01/05/2006,900) with "downtime" as the
text. I don't want to add a texbox and manually position it.

I tried using the xychartlabeler (works great) but I need the ability to add
several lines of text with different colors.