Plot 7 bars and 1 line on a chart
 

How do I use the combo chart to plot 7 bars and 1 line on a chart? Excel
wants to make it to be a 4 bar and 3 line chart.

Plot 7 bars and 1 line on a chart
 

Select the first line/series you want to be a column, then Chart/Chart Type,
and making sure "Apply to selection" is chosen, select Column chart. Press
the up arrow (selects the next series), then press F4 (repeats changing that
line to a column), and so on until you've only got one line left.

Bob Umlas
Excel MVP

"BigBunny" wrote in message
...
How do I use the combo chart to plot 7 bars and 1 line on a chart? Excel
wants to make it to be a 4 bar and 3 line chart.