Edit DataLabel in Excel charts

Hot Topic

How to create a menu & submenu ?
Please Help...When running a VB macro in Excel the date changes format to USA from UK !!
Applying one cell's formatting to another cell
Sum of hours using select statement & VBA
Automating PowerPoint
Report links to other files
Using VBA macro to locate next free column on worksheet
excel worksheet interface coding
Please Help...When running a VB macro in Excel the date changes format to USA from UK !!
Please help!!! Run-time error '13' : Type mismatch

Microsoft ISV

Batchs of Subs ! But How ??
Registering as ISV
I am searching a VBS scripting example for a free form path item in Adobe Illustrator
Userform Controls
How do I...
Access Frontend vba changes
Access and Graph
A vector of vectors
how create new entity in crm 3.0
Microsoft Office Document Image Writer -- partial print

Edit DataLabel in Excel charts

Hi all,

I wonder have I can add a Legend Key(a line that goes from the point in the chart to DataLabel text) to the DataLabel in the code below I would also like to now how I can change the position of the DataLabel.

With ActiveChart
    With .SeriesCollection(1).Points(2)
        .HasDataLabel = True
        .DataLabel.Text = "Saturday"
    End With
End With

Thankful for tips.

Jonas




Answer this question

Edit DataLabel in Excel charts

  • DrewW

    Thanks Andy!

  • ACCOUNTINGONLINE.US

    Maybe this example of leader lines will help.
    http://www.andypope.info/ngs/ng14.htm

    To change the position of the data label you can use code like this.

    ' using built in label positions. Positions available depend on chart type
    activechart.SeriesCollection(1).points(2).datalabel.position = xlLabelPositionAbove

    ' or explicitly set position of label using Left and Top values
    activechart.SeriesCollection(1).points(2).datalabel.Left = 30
    activechart.SeriesCollection(1).points(2).datalabel.Top = 30



  • Edit DataLabel in Excel charts
Answer this question