how do I create a chart on two axes with stacked columns and line

G

Guest

I am struggling to create a chart that combines stacked columns on one X axis
with a line on a second axis. Both are available as standard charts.
 
A

Andy Pope

Hi,

Create the stacked column chart with all of your data.
Select the data series you want to plot as a line on the secondary axis.
Change the chart type to line. And then on the format dialog change the
axis to the secondary.

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 chart with line 1
superimposed 3-D stacked area charts 2
stacked column graph adjacent to a regular column graph 0
Stacked Bar - 2 Axes 1
X-Axis Units Disappear in Stacked Area Chart (Excel 2007) 0
stacked bar, and column, two axes 2
Two-Axes, Stacked and Line Chart 1
Stacked column chart - before and after? 1

Top