Excel Chart of 2 'types'

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
 
Back
Top