Bar and Line Chart

[kaci]

Hello all experts here,

I would like to create a chart with two bars and three lines. But it seems
if i input more than 4 types of data, the excel only allows me to do 3 bars
and 2 lines.

Please kindly advice. Thanks million!!

 

[Jon Peltier]

That's the problem with the built-in custom types, too inflexible. Start
with a line chart using all five series. Select one that you want to change
to a column (the vertical bars in Excel are called columns), and use Chart
Type on the Chart menu to change it to a column. Select the next one to
change, and either go back to Chart Type, or press the F4 function key,
which is the universal shortcut for Repeat Last Action.

- Jon