software

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 quot;downtimequot; 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.

Use the chart labeler. Every differently formatted item can be put into its
own label (different colors in different labels). I do this all the time,
and everyone thinks it's magic.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
PeltierTech.com/
_______

quot;Monaquot; gt; wrote in message
...
gt;I am adding textboxes to a line chart. Is there anyway to add a textbox
gt; (VBA?) using my chart xy coordinates?
gt;
gt; 01/02/2006 300
gt; 01/03/2006 400
gt; 01/05/2006 900
gt; 01/06/2006 300
gt; 01/07/2006 350
gt;
gt; I would like to center a textbox at (01/05/2006,900) with quot;downtimequot; as
gt; the
gt; text. I don't want to add a texbox and manually position it.
gt;
gt; I tried using the xychartlabeler (works great) but I need the ability to
gt; add
gt; several lines of text with different colors.