Jump to content

 

Photo

Bubble Chart: Label beside DataPoints


  • Please log in to reply
5 replies to this topic

#1 Henryk

Henryk

    Member

  • Members
  • PipPip
  • 15 posts

Posted 18 June 2008 - 08:44 AM

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).

#2 vivek

vivek

    Advanced Member

  • Team Visifire
  • PipPipPip
  • 3,605 posts
  • Gender:Male
  • Location:Bangalore

Posted 18 June 2008 - 10:57 AM

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.

Regards,
Vivek
Team Visifire


#3 GannonE75

GannonE75

    Newbie

  • Members
  • Pip
  • 3 posts

Posted 09 May 2012 - 03:56 AM

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

Attached Files



#4 shoaib

shoaib

    Advanced Member

  • Members
  • PipPipPip
  • 924 posts
  • Gender:Male
  • Location:Bangalore

Posted 09 May 2012 - 04:56 AM

Hi Gannon,

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

Regards,
Shoaib

#5 GannonE75

GannonE75

    Newbie

  • Members
  • Pip
  • 3 posts

Posted 09 May 2012 - 09:47 AM

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?

#6 shoaib

shoaib

    Advanced Member

  • Members
  • PipPipPip
  • 924 posts
  • Gender:Male
  • Location:Bangalore

Posted 10 May 2012 - 05:21 AM

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




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users