Make the chart as a line chart. Select each series to change to a column,
and use Chart Tools Design tab Type Change Chart Group to change just
the selected series to a column. Repeat for other series you need to change.
Then select each series you want to put onto the secondary axis, press
Ctrl+1 (numeral one) to bring up the Format dialog, and on the Series
Options tab (I think) choose the secondary axis option.
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. -
http://PeltierTech.com
_______
"stnelson" wrote in message
...
How do I create a Line-Column on 2 Axis Chart in Excel 2007