How do I set up a chart in Excel with lines and stacked bars?

G

Guest

I am trying to set up a chart that will have stacked bars overlayed with a
line graph. Is this possible to do?
 
B

Bernard Liengme

First make the chart as a stacked columns chart.
IN the chart, right click on the data series to be a line; select Chart Type
and specify Line
best wishes
 
A

Andy Pope

Hi,

Yes it is possible if you are not using the 3d styles.
Create the stacked column chart based on all your data. Then select the
series you want to plot as a line. Use the menu Chart > Chart Type... to
select the required line chart style.

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

Stacked Line Chart 3
Stack Bar Charts 1
Multiple stacked clustered bars 1
Stacked bar Chart in Excel 2007 1
Stacked Color Charts 1
line-column combination chart, with stacked columns 1
Combination Stacked Bar and Line Graph 1
Stacked Bar and Line on Same Graph 2

Top