Stacked column graph

[Vikingex]

Hi,

I would appreciate any help I coluld get with understanding these graphs. I have attached an image of what I am trying to achieve.

Is it possible to remove the blue area for item 2? So just show the variance from the first item? I know I can just make the bottom half invisible colour, but surely this is not the correct way of doing things.

Any help is appreciated.

TIA

[Andy Pope]

Perhaps what you are after is the construction of a waterfall chart?
http://peltiertech.com/Excel/Charts/Waterfall.html

[msbaath]

I finally know how to make waterfall graphs! thanks