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

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" <(E-Mail Removed)> wrote in message
news:B33B6B64-EBB6-4F3B-A4D0-(E-Mail Removed)...
>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
>