Is it possible to have a Line - Stacked Column Chart?

G

Guest

I am trying to create a chart with a stacked column plotted on the primary
axis and a line on the secondary axis. I have seen the custom chart type of
a Line - Column chart, but I want to stack the columns. Is this possible?
 
A

Andy Pope

Hi,

Ignore the builtin custom types and just create your own.
Start with a stacked column chart of all your data and then double click
the series that you want on the secondary axis. Change the setting to
secondary via the Axis tab of the format dialog.
Then right click the series and change the chart type to Line.

Cheers
Andy
 
G

Guest

Thank you very much!

Andy Pope said:
Hi,

Ignore the builtin custom types and just create your own.
Start with a stacked column chart of all your data and then double click
the series that you want on the secondary axis. Change the setting to
secondary via the Axis tab of the format dialog.
Then right click the series and change the chart type to Line.

Cheers
Andy
Click to expand...
 

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 column graph adjacent to a regular column graph 0
secondary category axis reset to min=0 max=0 on save 1
X-Axis Units Disappear in Stacked Area Chart (Excel 2007) 0
Excel 2003 - Combination chart: Stacked Column + Stacked Column 3
How do I combine stacked and clustered chart types? 2
How can I combine a stacked column chart and line chart? 1
Stacked column chart - before and after? 1
Stacked columns width too thin - how can I alter? 1

Top