Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
maperalia
 
Posts: n/a
Default ChartLabeler Questions

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

  #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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
I'm having trouble finding my posted questions? treybreak Excel Discussion (Misc queries) 1 April 27th 06 02:15 PM
ChartLabeler Question?? maperalia Charts and Charting in Excel 0 March 23rd 06 05:01 PM
questions regarding range's trav Excel Discussion (Misc queries) 3 February 24th 06 06:06 PM
Excel - how can I practice formulas on financial questions? flamingformulas Excel Discussion (Misc queries) 4 February 20th 06 03:18 PM
Pivot Table for survey data w/ questions as Rows & poss answrs as pfwebadmin Excel Discussion (Misc queries) 0 May 17th 05 02:31 PM


All times are GMT +1. The time now is 10:39 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"