Bubble Chart Labels 2

[BlaineR]

Hi,

In my Excel 2007 bubble chart, I want to label my bubbles using the associated values in a column called Project Name.

I know that "out of the box", Excel lets you label using: Series Name or X Value or Y Value or Bubble Size -- but I don't want these.

I know I could also "manually" go in to each label and make a reference to the associated cell in the Project Name column, but this is pretty tedious.

I'd appreciate any suggestions.

Thanks,
Blaine

 

[SkipVought]

Hi,

1. Assign a NAMED RANGE of BubbleName to the names you want the bubble data labels.

2. Select your chart

3. run this code...

Sub NameBubbles()
    Dim pt As Point, i As Integer
    
    With ActiveChart
        .SeriesCollection(1).HasDataLabels = True
        i = 1
        For Each pt In .SeriesCollection(1).Points
            pt.DataLabel.Caption = Range("BubbleName")(i)
            i = i + 1
        Next
    End With
End Sub

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[BlaineR]

Sweet! Works like a charm. You're awesome, Skip.

Thanks,
Blaine