Change size and position of data labels using vba in excel

Поделиться
HTML-код
  • Опубликовано: 3 окт 2024
  • Sub data_labels()
    Dim s As Series
    Dim i As Integer
    Set s = ActiveSheet.ChartObjects("Chart 1").Chart.FullSeriesCollection(1)
    For i = 1 To s.Points.Count
    s.Points(i).DataLabel.Width = 130
    s.Points(i).DataLabel.Height = 15
    s.Points(i).DataLabel.Left = s.Points(i).Left - 130
    s.Points(i).DataLabel.Top = s.Points(i).Top - 8
    Next i
    End Sub

Комментарии • 2