Combining stack column chart and non stacked

[gordon_conroy]

Hi All
Need to combine 2 charts
I have the Exp below in a stacked column chart and I can combine i
with Revenue as a line chart to view both of them together.My proble
is I want to see the Revenue as a column right beside the stacke
column

Cheers,
Gordon

yr1 yr2 yr3
Exp1 3 4 5
Exp2 1 2 3
Exp3 6 7 8

Revenue 5 20 1

 

[Andy Pope]

Hi,

Stacked cluster charts can be created by careful layout of your data.
Jon Peltier has details
http://peltiertech.com/Excel/ChartsHowTo/ClusterStack.html

Cheers
Andy