Labelling at xy scattered chart

K

kl

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 !!
 
J

Jon Peltier

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/
_______
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top