Unfortunately the labeler cannot keep up with dynamic data ranges. What I do
if I need a dynamic chart that will grow, is set up the dynamic ranges, then
add as much dummy data and labels as I imagine I'll ever have of real data.
I apply the labels to this artificially large region, then I clear the
cells. As points are added, the individual points remember which cell their
label had come from when the labels were first applied.
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______
"maperalia" wrote in message
...
I have been using the ChartLabeler from appspro.com that by the way it is
fantastic!!!!!!. in all my charts to add difference kind of labels
However, I have noticed that every time I have new data to load in my
chart
the chartlabeler does not update automatically the new points loaded in
the
graph. I have more than 30 graphs in this file and I have to add the label
again to
each graph to get the new point with the label.
Do you know if there is any way to automate this chartlabeler?
I will appreciate you helping with this matter.
Maperalia