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
http://PeltierTech.com/
_______
"Mona" wrote in message
...
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.