Is there a way to change the DataPoint LocationType on an every other point basis? For example, for the first data point, the location type would be above the point, for the second it woul be a below the point, and so on?
With .Item(1).DataPoints(-1)
.DataPointLabel.LocationType = VtChLabelLocationTypeAbovePoint
.DataPointLabel.VtFont.VtColor.Set 0, 0, 0 '# black text
.Brush.FillColor.Set 255, 0, 0 '# red line
End With
Thanks,
Gary
With .Item(1).DataPoints(-1)
.DataPointLabel.LocationType = VtChLabelLocationTypeAbovePoint
.DataPointLabel.VtFont.VtColor.Set 0, 0, 0 '# black text
.Brush.FillColor.Set 255, 0, 0 '# red line
End With
Thanks,
Gary