Adding Multiple Lines On A Secondary Axis?

[al]

I am working with a line-column on 2 axes chart . Columns are charted on the
primary axis and a line is charted on the secondary axis. I am trying to add
a second line to the secondary axis. Can anyone help?

Thanks

 

[Andy Pope]

Hi,

One way is to use the Add button on the Series tab of the Source data
dialog. Right click chart and pick Source Data from the context menu.

If the new series is not automatically a line series simply select it,
right click and choose Chart Type. Select required line chart.

You can also use copy and Pate special to add data to a chart.

Cheers
Andy