combination bar chart

[sgetraer]

I have a simple chart that has 5 elements and 6 data points for each element. I want to show 4 of the elements as a bar and one as a line... When I try to do this, excel keeps on setting up 3 as a bar and and 2 as a line. That does not help me. What am I missing?


I have attached a file to show the problem

[JeteMc]

The formulas in cells B19:G23 reference another file to which we have no access. Once editing is enabled those cells display #REF! errors which in turn cause B26:G30 to display #REF! errors and there is no data for the graph.
Please upload another file with the numbers in B19:G23 converted from formula results to values or have the formulas reference values on another sheet in the same workbook.
Let us know if you have any questions.

[Andy Pope]

Is that the default choice given the dimensions of the data.
Once you have a chart you should be able to select as series and then use the Change Chart Type dialog to specify exactly what chart type each series should be.