View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
Andy Pope Andy Pope is offline
external usenet poster
 
Posts: 2,489
Default Adding Multiple Lines On A Secondary Axis?

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

al wrote:
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, Microsoft MVP - Excel
http://www.andypope.info