If you are using Excel 97 to 2003, the link will keep pointing to the
reference cell if you insert or delete rows or columns that change the link.
However, if you are using Excel 2007, the link will not stay pointed to the
reference cell. It appears to do so, until you change the value in the
reference cell after inserting or deleting that should change the reference.
A big bug in 2007......
Robert Flanagan
http://www.add-ins.com
Productivity add-ins and downloadable books on
VB macros for Excel
"LFNFan" wrote in message
...
Hi
Does anyone know if the AppsPro XY Chart Labeler is able to dynamically
update data point labels on a chart if the data in the 'label' cells
changes?
I would like to know before I install the .exe file.
I have an XY chart with 256 data points derived from a 'master' formula
with
various inputs. If I change an input, the data point values will change
and
so will the associated labels.
Many thanks