View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier
 
Posts: n/a
Default ChartLabeler Questions

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