Series.AxisGroup (Excel)

Returns or sets the group for the specified series. Possible return values are xlPrimary - Primary axis group, xlSecondary - Secondary axis group.

ActiveChart.FullSeriesCollection(1).AxisGroup = xlPrimary