Line and a Col on 2 axis in Office Excel 2007

[jake the peg]

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

 

[Andy Pope]

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

 

[jake the peg]

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






- Show quoted text -

Andy,

thank you very much

All the best

Jake