Labelling bars in a chart???

Caminham
07-20-2003, 06:39 PM
Hello,

I have found the forum an extremely valuble resource in the past, thank you!

I'm working on a little project which has caused me a lot of problems. At the moment the problem is getting values to display on my bar chart (see attached pic). I know it's possible in excel.

Basically I want the values of each bar to sit on top of the bar.

Thanks for all the help,
Cameron

Caminham
07-20-2003, 08:47 PM
I worked it out.

With Graph
For i = 1 To .Plot.SeriesCollection.Count
With .Plot.SeriesCollection(i).DataPoints(-1).DataPointLabel
.LocationType = VtChLabelLocationTypeOutside
.Component = 1
.VtFont.Size = 10
End With
.Plot.SeriesCollection(i).LegendText = intLabels(i)
.ColumnLabelCount = 2
.Column = i
Next i
End With

EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum