Excel charting - Scenarios plotted as bars and lines

[monish_rk]

I'm creating a custom line column chart on 2 axes. The data comprises of the following which I would like to chart out:

Year Revenue (1,2) Results for the year(1,2) Cumulative results (1,2)
1
2
3
etc.

(1,2) reflect each of two scenarios (best case and worst case).

When creating the chart I need to get the revenue (1,2) in columnar form (i.e. bars) , and results for the year (1,2) and cumulative results (1,2) as lines. By default this does not happen (there are 3 in columnar and 3 in bar form).

How can I get the 2 data points as bars and the other 4 data points as lines?

Thanks in advance.

Regards

 

[Jon Peltier]

Don't rely on the lame built-in custom chart types.

Make a line chart with all of your data. Then one by one, right click on each series you want to show as a column, choose Chart Type from the pop up menu, and select the column style you want.