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.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.