xlLabelPositionBestFit for Bubble Chart in Excel
Posted on 2012-03-20
When I try to set the datalabels position for a bubble chart to xlLabelPositionBestFit, it always fail with error, "Run-time error '91', Object variable or With block variable not set".
When i replace xlLabelPositionBestFit with xlLabelPositionBelow, xlLabelPositionAbove, xlLabelPositionCenter, it works.
My bubble chart labels just got so jammed together that i need to find a good way to space them out automatically.
Can anyone advise why the above doesn't work, and if there's a simple way to resolve the bubble chart label spacing problem?
Code segment below:
Set WorkingSheet = Worksheets(ChartSheetName)
Selection.Position = xlLabelPositionBelow
Many thanks in advance for your advice.