ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Labelling at xy scattered chart (https://www.excelbanter.com/charts-charting-excel/60962-labelling-xy-scattered-chart.html)

kl

Labelling at xy scattered chart
 
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

Jon Peltier

Labelling at xy scattered chart
 
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





All times are GMT +1. The time now is 03:59 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com