On Jan 31, 12:42*pm, "Andy Pope" wrote:
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 - Excelhttp://www.andypope.info
"jakethepeg" wrote in ...



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- Hide quoted text -

- Show quoted text -

Andy,

thank you very much

All the best

Jake