Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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!! |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
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!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|