Add labels to a bubble chart with multiple series

**wahlberg** · 03-16-2012, 11:11 AM

New Bubble Graph v5.zip

Hi, would appreciate help with this,

I'm creating a sales pipeline / bubble chart for business development and having trouble with the labels.

I found the code to attach labels to a scatter graph / bubble chart on the microsoft website and have managed to do this on a single series but do not know how to do the same for multiple series.

As you will see on the 'Funnel' tab I have, 2 charts on top of each other. 1 of these charts has all of the data in 1 series (from the 'Data' tab), and I have made these bubbles transparent so that it's only the labels which show once the macro is run. The other chart has a series for each stage (from the 'Graph Feed') tab. This was so I could preset the colours of the bubbles

I would like, as I have done on the 'Funnel by BDM' tab, to be able to select the Business Development Manager (BDM) from the drop down box and show only these bubbles.... which works, but the labels were going out of place.

So I would like to just have the one chart and run the macro to show the labels.

note

- the number of opportunities (bubbles) will change each month
- i have a 'scale' bubble which is to reduce the size of the other bubbles, I don't need a label for this but at worst I can just remove it individually
- if possible i'd like the font/size of the labels to be included within the macro code so i can change it (currently appears calibri each time macro is run which is ok but may want to change it and the size)

thanks!!

**wahlberg** · 03-17-2012, 04:07 AM

Please can anyone help?

**teylyn** · 03-18-2012, 04:14 AM

Hello,

the XY Chart Labeler add-in, available free here: http://www.appspro.com/Utilities/ChartLabeler.htm is immensely useful in creating chart labels. Combine that with a dynamic range name for the chart source, as explained here: http://peltiertech.com/Excel/Charts/Dynamics.html

cheers,

**wahlberg** · 03-18-2012, 01:56 PM

Hi, I have sort of managed to do it, but can't change the font size of the labels once done, it just seems to shift the position rather than increase the size

?

**teylyn** · 03-19-2012, 06:39 AM

Labels can be a bit finicky when it comes to formatting, especially with XL 2007. You may well have run into the limits.

I don't run 2007 any more, no fun in it. 2003 and 2010 are so much better when it comes to charting. But maybe someone else may have ideas.

**mmedeny** · 01-19-2013, 02:52 PM

Ran into this forum while researching. I work in consulting so have been battling the same bubble chart label issue for ages. The labeler tool helps but still so many wasted hours mucking around with formatting every time a client wants to see a different view. Searched far and wide yesterday and ran into a macro at excelvisualizations.com. Not free but a price of a late so I broke down and got it. Only used once for a very specific thing so can't say too much yet, but so far so good...

Hope this helps.

**protonLeah** · 01-19-2013, 10:19 PM

mmedeny
Welcome to the Forum, unfortunately:

1. Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.

2. Attach a sample workbook (do not post pictures).

When you are in Advanced reply, click on the paperclip to open the upload window.

View Pic

3. Ask specific questions.