Excel - need to format a chart in code

[HarryW]

Hi all.

I need to change one series that is plotted on my chart (a percentage series) to be plotted against a second Y axis because the scales of the two series are very different and you cannot see the percentage series very well at the moment.

If you right click on a data series on a chart in Excel 97, under the Axis tab there is a frame with the caption 'Plot Series On' and two option buttons, 'primary axis' and 'secondary axis'. If I change it to secondary axis manually, the two series are displayed much better, but I can't work out how I can do this in code.

Does anybody know where this property is? Or if it's even accessible in VBA?

[HarryW]

Silly me, I found it. I just recorded a macro and looked at the code