Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
al al is offline
external usenet poster
 
Posts: 363
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.charting
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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to place a secondary y axis bar in a bar chart next to two primary y axis bars? Dmitry Charts and Charting in Excel 2 May 4th 06 01:58 AM
Stacked Bar Chart with Secondary Axis Benjamin B Charts and Charting in Excel 7 May 15th 05 04:00 AM
Changing Secondary axis value units sherobot Charts and Charting in Excel 4 May 2nd 05 07:00 PM
Secondary Axis iris Charts and Charting in Excel 1 December 31st 04 05:55 AM
Problems with true value on secondary Y axis NeedHelp Charts and Charting in Excel 1 December 3rd 04 05:56 PM


All times are GMT +1. The time now is 06:28 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"