I am working on a xy scattered chart which has in x number of days and in Y
depth. I want to put labels on different points but respecting a x-y location
(I mean at a cetain depth on a certain day).

I want these labels to be automatically written and updated as chart grows
bigger with time passing and depth increasing.

Thanks for help !!

--
kl

There are several third party Excel add-ins which allow you to link data
labels to the contents of worksheet cells. Two good (and free) ones a

Rob Bovey's Chart Labeler, http://appspro.com
John Walkenbach's Chart Tools, http://j-walk.com/ss

You can write formulas in the cells that change labels according to various
conditions, so the labels in the chart change the way you want them to.

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


"kl" wrote in message
...
I am working on a xy scattered chart which has in x number of days and in Y
depth. I want to put labels on different points but respecting a x-y
location
(I mean at a cetain depth on a certain day).

I want these labels to be automatically written and updated as chart grows
bigger with time passing and depth increasing.

Thanks for help !!

--
kl