Plot 7 bars and 1 line on a chart

B

BigBunny

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.
 
B

Bob Umlas

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
 
Top