Bubble Chart

[BigMike]

Thanks Pep for the help with the centering of the Labels!

Here's another question, how do I fix the size of the Bubbles? I can fix the size of the Diamond in a line chart, but I can't seem to see how to fix the bubbles on the chart,

Code: Select all

'QuadrantChart.Legend.Symbol.WidthUnits = lcsPixels
             'QuadrantChart.Legend.Symbol.Width = 20

You showed me this for the Legend, is there something similar for the chart?

Mike

[Pep]

Hi Mike,

you can fix the size of all the bubbles using the following code :

Code: Select all

    For i = 0 To .Series(0).Count - 1
        .Series(0).asBubble.RadiusValues.Value(i) = 10
    Next i