Prev: copying chart to location within same workbook
Next: Excel Chart Lines
From: Barney on 11 Nov 2009 11:59
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
From: Jon Peltier on 11 Nov 2009 12:27
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
-------
Jon Peltier
Peltier Technical Services, Inc.
http://peltiertech.com/



Barney wrote:
> 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
 | 
Pages: 1
Prev: copying chart to location within same workbook
Next: Excel Chart Lines