software

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.

MaperaliaUnfortunately 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
PeltierTech.com
_______quot;maperaliaquot; gt; wrote in message
...
gt;I have been using the ChartLabeler from appspro.com that by the way it is
gt; fantastic!!!!!!. in all my charts to add difference kind of labels
gt;
gt; However, I have noticed that every time I have new data to load in my
gt; chart
gt; the chartlabeler does not update automatically the new points loaded in
gt; the
gt; graph. I have more than 30 graphs in this file and I have to add the label
gt; again to
gt; each graph to get the new point with the label.
gt;
gt; Do you know if there is any way to automate this chartlabeler?
gt; I will appreciate you helping with this matter.
gt;
gt; Maperalia
gt;