Datalabels not appearing on chart
I have a series plotted as error bars. I apply datalabels to the three values(think SPC here, namely Upper control limit, average, and lower control limit). On my home machine the three datalabels appear ==On another machine they don't. Both are running Windows 2000.
Code:
Set ns = ch.Chart.SeriesCollection.NewSeries
ns.Values = seriescont
ns.AxisGroup = xlSecondary
"Some other code"
With ns
.ChartType = xlXYScatter
.ErrorBar direction:=xlX, include:=xlMinusValues, _
Type:=xlFixedValue, amount:=30
End With
"Some other code"
With ns
.HasDataLabels = True
.MarkerStyle = xlNone
.ApplyDataLabels Type:=xlShowValue
.DataLabels.Position = xlLabelPositionRight
.DataLabels.Font.Size = 8
End With
This seems to be a common occurence with vba==all the machine specific problems==Any suggestions would be appreciated.