LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 6,582
Default How Do I Add Multiple Lines On Secondary Axis in Excel Chart?

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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


wrote in message
ups.com...
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?



 
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
Add vertical lines to a line chart (already has 2 Y axis) PaulW Charts and Charting in Excel 3 November 21st 06 04:19 PM
Secondary Axis chart McInnes Charts and Charting in Excel 1 September 16th 05 08:17 PM
tick mark labels Debrane Charts and Charting in Excel 9 July 19th 05 02:53 AM
How do I make the Y axis in an excel chart the category axis? megnadoodle Charts and Charting in Excel 2 March 29th 05 09:27 AM
How do I set permanent secondary axis in PivotTable chart? Microlong Charts and Charting in Excel 3 January 8th 05 03:54 AM


All times are GMT +1. The time now is 04:14 AM.

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"