How do I write text on a bar chart using VBA

  • Thread starter Thread starter Barney
  • Start date Start date
B

Barney

I have a worksheet with various bar charts. I want to write text inside the
bar but cannot figure out the correct control name to modify the text. Any
help is appreciated
 
You can add a data label to the data point.

With ActiveChart.SeriesCollection(1).Points(1)
.HasDataLabel = True
With .Datalabel
.Caption = "Hello"
.Position = xlLabelPositionCenter
.Orientation = xlUpward
'' and more if desired
End With
End With

- Jon
 
Back
Top