Dear Alex,
It seems(!) that the PivotChartOnAfterRefresh event is triggered before the refresh is complete: if I check the PivotChart1.SeriesCount in this event I find that I do not get the correct number of series. I need this because I want to set the ColorEachPoint variable if there is only one series (apart from the series[0] of course)
Maybe I'am doing something wrong, so please correct me if so
Kind regards, Bas van de Pavert