Hi everyone,
I know this has been answered many times before, but I'm looking for a slight tweak to the answer. I would like to have data labels added to a bubble chart (Excel 2007), but I don't want to use the add-in I see recommended often ("XY Labeler"?) because I will eventually need to turn over my Excel file to my client and I'm not sure if s/he will be able to download an add-in.
So, I'd rather have some VB code (with which I very little experience).
Thanks in advance!
Kelly
You could ask AppsPro for permission to distribute the add-in with your workbook.
Entia non sunt multiplicanda sine necessitate
Try using the macro recorder whilst linking an individual data label to a cell.
This will at least give you a starting point to writing your own code.
You know you do not need the addin once the links between cells and data labels has been made. It is only if the size of the data series increases or you create new charts that a problem will arise.
Andy,
Thanks for the response!
Best,
Kelly
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks