Center the label in a symbol
Posted: Mon Oct 11, 2004 7:52 pm
Hey Guys,
I'm building a Bubble chart, my labels are simple numbers 1, 2, 3, etc. they are showing up in the top of the symbol / bubble, is there a way to center the numbers?
Here is the code I'm using, i is the number / label.
[ adoRs.MoveFirst
Do Until adoRs.EOF
With QuadrantChart.Series(1).asBubble
.AddBubble adoRs.Fields(3).Value, adoRs.Fields(2).Value, 1.5, i, RGB(ChartColorRed(i), ChartColorGreen(i), ChartColorBlue(i))
i = i + 1
adoRs.MoveNext
End With
Loop][/code]
I'm building a Bubble chart, my labels are simple numbers 1, 2, 3, etc. they are showing up in the top of the symbol / bubble, is there a way to center the numbers?
Here is the code I'm using, i is the number / label.
[ adoRs.MoveFirst
Do Until adoRs.EOF
With QuadrantChart.Series(1).asBubble
.AddBubble adoRs.Fields(3).Value, adoRs.Fields(2).Value, 1.5, i, RGB(ChartColorRed(i), ChartColorGreen(i), ChartColorBlue(i))
i = i + 1
adoRs.MoveNext
End With
Loop][/code]