How do I do a combination STACKED column and line chart on 2 axis

R

rwtuning

I want to have a combination chart on 2 axis. I want the columns to be
stacked. I want the line to be on a second Y axis....please help!
 
A

Andy Pope

Hi,

Create the chart using all the data as a stacked column chart.
Double click the series that you want as a line on the secondary axis.
On the Axes tab select Secondary axis. The right click the series and
pick Chart type to change it the required line chart type.

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

sideways stacked bar charts with line series on the same axis 0
simple chart 0
column charts with set set of data 0
In a Line-column graph on 2 axes, how do I stack the columns? 1
Finding asymptote equation and how to draw them in excel 0
Use text descriptors as Y axis units 1
Chart data scrunches to left when adding X axis date series 0
Make Y-axis values correspond to x- axis value 1

Top