How to create chart with columns and 2 lines?

R

Robert

Excel will let me create a combination chart with two sets of columns and one
line. I'd like one set of columns and two lines. Can I get it to convert
the second data series from columns to line points?
 
A

Andy Pope

Hi,

Just create a standard line chart and the select the series you want to
plot as columns. Right click and choose Chart Types. Select the required
line chart.

Cheers
Andy
 

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

List all tables, including document structure 0
How to create a bubble chart with more than 2 variables. 0
Word VBA - Want to test if Full Name is NOT Present in document 0
Overlay line graph points on bar graph 1
Format column widths from one table to a separate table on same page 1
simple chart 0
Move Chart with Text 0
One extra x axis item that wont go away - can anyone help? 3

Top