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

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

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Gary T" wrote in message
...
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