3 columns and one line chart

  • Thread starter Thread starter Terry Carpenter
  • Start date Start date
T

Terry Carpenter

Hello!
I'm trying to create a chart from 4 rows of data. I need the first
three rows to be columns and the last row to be displayed as a line.
If I set my chart type to "line - column", I get the first 2 rows as
columns and the last 2 rows as lines.

Thanks!
 
Nevermind, I figured it out. I made a column chart and then selected
the column series I wanted as a line. Then I right-moused and selected
the line chart I wanted and ,viola!, 3 columns and 1 line!
 
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

create chart with column axis 10
Paste in column B using Last row of either column B, C or D. 10
Problem with a loop and column references 27
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
changing the source range of a chart 3
Program a combination chart using VBA 6
Excel Help to copy information from one row at a time to another sheet 1
convert columns to rows 6

Back
Top