Hi,

No combination charts as default in 2007, which is no bad thing.

Create column chart based on both sets of data.
Select the series you want as line on secondary axis.
Change the chart type to line.
Set the Axis to Secondary via the format dialog.

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"jake the peg" wrote in message
...
I used the line and col on 2 axis loads in the previous versions of
Excel but can't seem to find it in Office Excel 2007. Any ideas
anyone?

Thanks in advance for your help

Jake