Combination chart: 3 stacked columns + 1 line

G

Guest

Wanted to know if anyone has done this successfully:

3 stacked columns with a separte data series as a line. I am finding that
you can do a combination with: 2 stacked columns but not 3.

BTW: read 6/5/06 posting with Andy Pope response but did not address 3
stacked columns in the thread "Subject: Re: line-column combination chart,
with stacked ...
 
J

Jon Peltier

Forget all about the built in custom chart types. It's very easy to make
your own custom combinations that do what you want.

Make the chart using all series as stacked columns. Select the series you
want to change to a line, and use Chart Type from the Chart menu to change
its type.

- Jon
 

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

Excel 2003 - Combination chart: Stacked Column + Stacked Column 3
Clustered Stacked Chart 1
How can I combine a stacked column chart and line chart? 1
How to create a stacked bar, line combination chart 2
Combination Stacked Bar with Single Bar Chart 2
line-column combination chart, with stacked columns 1
Dynamic Chart Title With 3D Stacked Column Chart 2
Combination chart: primary data labels obscure line series on secondary axis 3

Top