We are trying to automate the creation of a column chart with two data
series, wherein one of the series is attached to the secondary axis. We
create two additional 'dummy' or blank series with zero values (two series
attached to primary axis; two series attached to secondary axis) so the
secondary column series does not 'jump' in front of the primary column series.

We cannot dictate the order of the series on the worksheet to the user, so
we need to be able to adjust the series order.

Does anyone know the code to manipulate the series order in Excel 2007?

Thank you very much.

Mike