ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Adding Multiple Lines On A Secondary Axis? (https://www.excelbanter.com/charts-charting-excel/119877-adding-multiple-lines-secondary-axis.html)

al

Adding Multiple Lines On A Secondary Axis?
 
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
--
al

Andy Pope

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


All times are GMT +1. The time now is 07:23 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com