Page 1 of 1

Bubble Chart

Posted: Fri Oct 15, 2004 10:31 pm
by 6921249
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

Posted: Sun Oct 17, 2004 3:06 pm
by 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