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 Charts on 2 axis'

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