Plot 7 bars and 1 line on a chart

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Control Z-Order of drop lines in an Excel 2007 chart? 2
Change color of points of scatter plot 1
Word On a bar chart I want to have just one horizontal line, crossing the y axis at a value I determine. 1
Finding the Y-Value of Points 6
PowerPoint Embed scroll excel chart and data in powerpoint 0
Help: Chart & data 1
Plotting duration of activity on a graph 1
Graphing a bounded region with a twist? 1

Back
Top