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 are:
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" <kl@discussions.microsoft.com> wrote in message
news:D8B30C40-2260-4626-95EC-5991AE9AF8A4@microsoft.com...
>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 currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks