I've been trying to add data lables to a line data series on a secondary axis via vba. The labels are not being displayed. When I try to add the data labels manually, I get the following message, "The maximum number of data labels that can be displayed is 1000. Some labels will be remitted from the chart" . The chart contains only 100 labels. I've attached the pdf file of the chart.
.Name = "Aggregate LIFR (Non-NEX)"
.Values = objXlDataSheet.Range("F:F")
.AxisGroup = 2
.ChartType = 65
.Format.Line.Weight = 1
.DataLabels.NumberFormat = "0.0%"