Bubble Chart Data Labels
I have created a bubble chart and it has values for the x axis, values for the y axis and values for the size of the bubbles themselves. I want to add data labels but the label itself to be a different value to the x,y and size of the bubble data.
The data points refer to data about a set of projects and I want the project names to appear next to the data points - not the x values, y values or bubble size values.
Some coding and explanation would be great.
Thanks.
Rob Bovey's free XY chart labeler add-in (http://www.appspro.com/Utilities/ChartLabeler.htm ) usually makes short work of this. Is that something that you can work with?
Originally Posted by shg
Unfortunately I can't use a separate add-in on this - thanks though. Looking for something I can use in alt+f11
Since I use the add-in, I'm not that familiar with the actual code for this.
How familiar are you with Excel's object model? http://msdn.microsoft.com/en-us/libr...ice.14%29.aspx It seems to me that the code should not be overly difficult. Simply assign the appropriate "formula" string (eg "=sheet1!A1") to the formula property of each datalabel object (eg chart(1).seriescollection(1).datalabels(1).formula="=sheet1!A1"). Put all of that inside of a For...Next/For Each...Next loop (are you familiar with For..Next loops?).
I know I have seen others post similar code for this before. I know that it can be a challenge to wade through search results, but you might try and see if you can find previously posted code.
It's not possible to attach text labels to bubble charts natively; so you need to use a macro if you can't use an add-in etc....
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks