How Do I Add Multiple Lines On Secondary Axis in Excel Chart?

[al_charbonneau]

I have an Excel chart that is a Line-Column on Two Axis. The primary
axis shows columns. I am able to add the secondary axis, a line to the
chart. My question is: can I add multiple lines to the secondary axis?

 

[Jon Peltier]

It's easier not to start with one of the built-in custom types. They are
less flexible than you'd expect.

Make the chart using all columns or all lines. Select a series you want to
change to the other type, then use Chart menu > Chart Type to change it.
Select another series to change, and press the F4 function key to repeat the
previous action. Repeat as necessary. Then double click a series you want on
the secondary axis, and on the Axis tab, select Secondary. Select a second
series to change axis, and press the F4 function key. Repeat as necessary.

- Jon