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.
This seems to be a common occurence with vba==all the machine specific problems==Any suggestions would be appreciated.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