Bar and Line Chart
 

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!!

Bar and Line Chart
 

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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"kaci" wrote in message
...
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!!