View Single Post
  #2   Report Post  
John Mansfield
 
Posts: n/a
Default

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...?