Neoteny Posted October 15, 2007 Report Share Posted October 15, 2007 When plotting a bubble chart with automatic axis scaling (for both x- and y-axis) it seems that the calculated value for the axis.max is the center of the outermost bubble, not taking into account the diameter of the bubble. the topmost and rightmost bubble(s) are cut in half. Sorry to say, but this doesn't look good. One would expect that automatic scaling takes the bubble diameter into account. I don't want to switch to manual scaling because I don't know in advance what the range is for the data the chart is fed with, and I don't want to program complex calculations to make corrections for the bubble diameter. I'd expect the control to solve this problem. Is there any chance for a quick fix? Example code: Dim i As Long Dim j As Long Dim ns As Long Dim np As Long Dim v As Long ns = 3 np = 3 v = 1 With Chart1 .OpenData COD_Values, ns * 2, np .OpenData COD_XValues, ns, np For i = 0 To (ns * 2) - 1 Step 2 .Series(i + 1).YAxis = YAxis_Secondary .AxisY2.Visible = False For j = 0 To np - 1 .Value(i, j) = v .Value(i + 1, j) = v .XValue(i, j) = v v = v + 1 Next j Next i .CloseData COD_XValues .CloseData COD_Values .Gallery = Gallery_Bubble End With Quote Link to comment Share on other sites More sharing options...
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.