Line and a Col on 2 axis in Office Excel 2007

J

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
 
A

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
 
J

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 -
Click to expand...

Andy,

thank you very much

All the best

Jake
 
Top