add data labels in charts with tools (dynamically)
 

I try to use both ROb Bovey and JWalk's tools to add data label to a scatter
chart. As I need to do the same chart for each sheet in a workbook I try to
copy and paste it in each sheet...the charts itself runs good, while data
label (that refers to cell located in the same position for every sheet)
disappear and I must re-insert them manually?
Where do I get wrong...?

These VBA code within these tools specifically points to the chart series
within a given sheet. As a result, if you copy charts to different sheets,
the labels will not follow.

Both tools are working as designed. It's just that they were not designed
with the thought that someone would be doing what you are. Unfortunately, I
believe you'll need to relabel each chart as it is moved to a different sheet.

----
Regards,
John Mansfield
http://www.pdbook.com

"uriel78" wrote:

I try to use both ROb Bovey and JWalk's tools to add data label to a scatter
chart. As I need to do the same chart for each sheet in a workbook I try to
copy and paste it in each sheet...the charts itself runs good, while data
label (that refers to cell located in the same position for every sheet)
disappear and I must re-insert them manually?
Where do I get wrong...?

You also have to redefine the data range for the plotted points, too,
don't you? It would be easier to copy the entire sheet complete with its
chart (I assume it's an embedded chart?). Right click on the sheet tab
and choose Move or Copy, and copy it within the same workbook. Then copy
a new set of data over the old (including data for labels and points),
and the new chart and its labels will update.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

uriel78 wrote:

I try to use both ROb Bovey and JWalk's tools to add data label to a scatter
chart. As I need to do the same chart for each sheet in a workbook I try to
copy and paste it in each sheet...the charts itself runs good, while data
label (that refers to cell located in the same position for every sheet)
disappear and I must re-insert them manually?
Where do I get wrong...?