Column with Stacked Column

[Ally]

I have three rows of financial (three scenarios) data for 5 years. I would
like to compare a chart of column for first scenarios vs. a stack column(for
the total of second scenario and third scenario together). I know I need to
set up a combination chart...can anyone explain to me how I am supposed to do
it? I tried three rows first with column chart... and was trying to change
the second and third column to stacked column... however, all three columns
changes to stacked column, which is not what I want. I still want to main the
first column but only the second and third combined to one stacked column...
Can anyone please help me?

THanks,

Ally

 

[Debra Dalgleish]

Jon Peltier has information and links for clustered stacked columns on
his web site:

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

You could adapt one of those techniques to create the stacked column and
single column.