Combination chart: 3 stacked columns + 1 line

L

Lancecar

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

sideways stacked bar charts with line series on the same axis 0
Stacked Line Chart 3
Clustered Stacked Chart 1
Combo Stacked column/column/line 1
Stacked Line Chart - Excel 2007 - Controlling the separation 2
Stacked Chart 2
Dynamic Chart Title With 3D Stacked Column Chart 2
Problem with stacked column chart 5

Top