Secondary Axis line chart formatting

I have a bunch of charts that I need to plot voltage and current measurments on primay and secondary axis respectivly.

Is there anyway to do this when I create the chart? Each chart will have four different series on the primary axis and eight on the secondary.

The problem I have is when creating the chart everything gets put on the primary axis. when I select a data set and place it on the secondary axis Excel automatically adds markers to the line. Now I have to go it and remove the markers.

This just creates more work for me.

Is there any way to place a data set on the secondary axis without Excel adding markers or doing anything else I did not ask for?

I am using Excel 2003-SP3

I have included an example. Chart 1 is the defalut line chart output Chart 2 is the same defaults as Chart 1 but I placed the second series (Line 2) on a secondary axis.

Notice that Excel changed the line style to a line with markers.

Now on a chart with only two series its no bit deal, but larger charts with more data points in each series that are close in value this becomes a real P.I.A. to go back and reformat every line that Excel changes.

Thanks!

Now how do I use that code?