Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I'm having trouble finding my posted questions? | Excel Discussion (Misc queries) | |||
ChartLabeler Question?? | Charts and Charting in Excel | |||
questions regarding range's | Excel Discussion (Misc queries) | |||
Excel - how can I practice formulas on financial questions? | Excel Discussion (Misc queries) | |||
Pivot Table for survey data w/ questions as Rows & poss answrs as | Excel Discussion (Misc queries) |