Modify series order

Hi,
In XL07 (SP2) I've a file with over 100 charts embedded in sheet.

All charts are the same type and have 3 series.
Series 1 has the category X label reference, series 2 & 3 have none.

I now need to change the order of the series
move series 1 to plot order 3
move series 3 to plot order 1

I'm trying to do this with VBA.

I've trolled through MSDN and this forum but haven't found something I can use.

Any ideas / insipiration welcome

Thanks JB

Please Login or Register  to view this content.