5 replies to this topic

[Henryk]

I have to create a bubble chart with the following requirement:
Each DataPoint must show its label permanently beside the bubble (no tooltip).

Is this possible? And is or will it be possible to set the position (top, bottom, left, right, over/center)?

Thanks (also for the last help).

[vivek]

I have to create a bubble chart with the following requirement:
Each DataPoint must show its label permanently beside the bubble (no tooltip).

Is this possible? And is or will it be possible to set the position (top, bottom, left, right, over/center)?

Thanks (also for the last help).

Hi Henryk,

Currently Visifire doesn't support positioning of Labels (Left/Top/Bottom/Right). There is a predefined position set for the labels.

[GannonE75]

I want to know the latest version can solve this problem?
My bubble chart still cannot change the label position as below:

Attached Files

•  Capture.PNG   11.91K   2 downloads

[shoaib]

Hi Gannon,

If you want to show the label inside the DataPoint then try setting AutoFitToPlotArea to True in DataSeries.

Regards,
Shoaib

[GannonE75]

When I record a macro of creating a bubble chart and moving a data label in Excel

Sub Macro1()

'

' Macro1 Macro

'

'

ActiveSheet.Shapes.AddChart.Select

ActiveChart.SetSourceData Source:=Range("'Sheet1'!$A$1:$D$4")

ActiveChart.ChartType = xlBubble

ActiveChart.SetElement (msoElementDataLabelRight)

ActiveChart.SeriesCollection(1).DataLabels.Select

ActiveSheet.ChartObjects("Chart 4").Activate

ActiveChart.SeriesCollection(1).Points(4).DataLabel.Select

Selection.Left = 259.344

Selection.Top = 151.61

End Sub

Could you use code like this to find where each label (Points) are placed (.Left, .Top) and adjust if two seem in the same location?

[shoaib]

Hi Gannon,

You have to adjust the label position by setting LabelAngle property in DataPoint. But if you will set AutoFitToPlotArea property in DataSeries, all clipped DataPoints will be placed inside the PlotArea and labels for those DataPoints will be placed inside thereby avoiding overlap.

Regards,
Shoaib