Excel Chart of 2 'types'

[Guest]

Hi

I'm trying to construct a chart in Excel 2007 which will allow me to have
the following:

A column chart for data Series 1;
A line graph chart for data Series 2;

but both Series 1 and Series 2 would be on the same chart.

How do I get Office 2007 to do this?

Regards

 

[Andy Pope]

Hi,

Create a column chart based on both series. Select the second series and on
the Chart Tools > Design > Type > Change Chart Type.
Select required line type.

Cheers
Andy