View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier Jon Peltier is offline
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?