Hi,
I have a PivotChart with 2 bound Axis:
.PivotAxis.Add(New PivotItem With {.FieldMappingName = "Jaar", .TotalHeader = ""})
.PivotAxis.Add(New PivotItem With {.FieldMappingName = "Maand", .TotalHeader = ""})
I try to customize the labels with code. With 1 PivotAxis this code works fine (BronMaandLabels is an Array of String):
With Chart.ChartControl.PrimaryXAxis
.Title = "Maanden"
For t = 0 To .GroupingLabels.Count - 1
.GroupingLabels(t).Text = BronMaandLabels(CInt(.GroupingLabels(t).Text))
Next
End With
With 2 Axis I get an error... Is there a way to customize the labels with 2 PivotAxis?
Regards,
Matthijs