Customizing Labels on a 4 Dimensional Bubble Chart

Hi,

I am looking for help related to labels on a 4 dimensional bubble chart that I am creating.
1) The labels on each bubble is represented by 'Team Name' and 'Headcount'
2) I need to separate these two labels, where the 'Team Name' is displayed right below each bubble, and 'Headcount' is displayed in the center of each bubble.

I am also sharing the excel file that I have created for this.

Any guidance/help will be greatly appreciated.

Thank you in advance!!

Hi

I'm at work, cannot test now, but...

1 -
A very simple solution seems to be to duplicate each series.

Add 2 series with the same x, y and bubble size.
The points superpose and so it will seem like it's just one series, but you'll have 2 independent labels for each point.
You can then position them, one below and the other at the center of the bubble.

2 -

Another solution would be
- to use the datalabel to write for ex. the team name below
- to add a textbox at the center of each point to display the headcount


Notice that
for solution 2 this means that each time a point changes position or the chart is resized or altered you may have to reposition all the textboxes.
This does not happen with solution 1, that adjusts the positions of the labels automatically.



Remark: About the team name in the label.
I see in your profile that you are using xl2010?
If you are developing in excel 2013+ you can display the Team Names directly using the options "values from cells"
Else you must edit the labels, manually or with vba.

How did you do it in your example?