Needed: Chart that combines clustered column and stacked column types

[Gerry]

The chart is to show projected financials for a business.

- Using Clustered Columns, I can show Revenue and Net Income. Not a
problem.
- Using Stacked Column, I can show the contribution to Revenue from
each of the businesses two product lines. Not a problem

What I would like to do is to combine these into a single chart: Show
a Stacked Column with the Revenue contributions and next to it
(Clustered Column) show Net Income.

Is this possible? If so, can you please explain how to do this.
Posting a simple example would be a bonus.

Many thanks.

gerry <at> pairofdocs <dot> net

 

[fujing1003]

The chart is to show projected financials for a business.

- Using Clustered Columns, I can show Revenue and Net Income. Not a
problem.
- Using Stacked Column, I can show the contribution to Revenue from
each of the businesses two product lines. Not a problem

What I would like to do is to combine these into a single chart: Show
a Stacked Column with the Revenue contributions and next to it
(Clustered Column) show Net Income.

Is this possible? If so, can you please explain how to do this.
Posting a simple example would be a bonus.

Many thanks.

gerry <at> pairofdocs <dot> net

@ gerry
There're at least two solution for your question.
(1)You could use second axis to solve this question. make a Clustered
Column in first axis and make Stacked column
in second axis.
(2) Just use the chart type of Clustered column, but rearrange your
souce data.
such as follows.
Jan
Fer Mar
Net Income. 10
12 14
Revenue contributions 1 4
6 9
Revenue contributions 2 6
6 5

Maybe you could find what you want in http://peltiertech.com/Excel/
Charts/ChartIndex.html
Good luck!
yours,fujing

 

[Jon Peltier]

Try the links on this page:

http://peltiertech.com/Excel/ChartsHowTo/ClusterStack.html

- Jon

 

[Gerry]

Thanks both - got it to work. Took a while to find the magic check box
so that things lined up just right...