Hi All,
Pls see attached relevent graph, i'll appricaite your help to add the names (column A) into the scatter of the data labels.
Thanks
Hi All,
Pls see attached relevent graph, i'll appricaite your help to add the names (column A) into the scatter of the data labels.
Thanks
here's a little macro I use.
and here's the file tooPlease Login or Register to view this content.
Happy with my advice? Click on the * reputation button below
Thanks a lot. looks good!
I'm not sure how can i update the name. for example, why the file isn't refreshing when i change A2 from a to w,
Thanks a lot
You need to select the chart then run the macro. It should update when you run the macro
If you want to link the data labels to the cells, then select the chart and run this code once:
Then when you change the cells, the data labels should update automatically.Please Login or Register to view this content.
If you are interested, rob bovey has written an add-in for this: www.appspro.com -- free utilities -- XY chart labeler add-in
Originally Posted by shg
Thanks a lot
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks