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

I

ian ian ian rogers

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
 
Top