I have a number of PivotCharts with data tables, each linked to a PivotTable.
The fields in each PivotTable are broadly similar and in exactly the same
order and for all but one of the charts, the order is A, B and C. However,
for one PivotChart, the order on the chart and in the data table is B, A, C -
even though the Series Order dialog says it's A, B, C and the
SeriesCollection(1) correctly points to A.

This is proving a problem as my single macro to auto-update on refresh
relies on the fields being in the order A, B, C... so it doesn't work for
this one chart.

I have tried rebuilding the PivotChart and the PivotTable but it just
refuses to draw the graph in the same order as the others... any ideas why
this is happening? And what I can do about it...?

Thanks,
Mark