I am making a combination chart and am only able to include the first 3 data
series with the column chart part. The rest of the series are all included
with the second series which has a much larger value.
Ignore "combination" charts, you don't need the hassle. They rarely
provide the solution you want. Just go in, click on the series that are
inappropriately lines, right click and select "Chart type", and turn
them into the columns you want.
The basic thing to remember is that "Chart type" belongs to each series
separately; you don't have to find a chart in the menu that's two
columns and three lines, or four areas and a scatter series. You can
just make each series a column or a line as you wish.
