Thread: How do I write text on a bar chart using VBA
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier[_2_] Jon Peltier[_2_] is offline
external usenet poster
  
Posts: 461
Default How do I write text on a bar chart using VBA
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
Reply With QuoteReply With Quote