Hi,
Start by creating a standard column chart.
Now select 1 of the column series that you want as a line.
Right click and chose Chart Types. Select Line chart.
That should have now changed the data series to a line.
Select another column and this time press F4, which will repeat the last
action. Repeat for the final series.
Or maybe its easier to create a line chart of all 4 and the change 1
series to column using the same technique as above.
Cheers
Andy