I am unsure if I can use any chart to show the following simple comparison
with the total and detail changes.

Plan Actual

Sept orders 50 40
New orders 0 20 (for Sept)
Cancelled orders 0 10
Total orders 50 60

Your advice is appreciated.

Ray

Take a look at Jon Peltier's site about waterfall charts.

http://www.peltiertech.com/Excel/Cha...mat.html#Falls


"Ray" wrote in message
...
I am unsure if I can use any chart to show the following simple comparison
with the total and detail changes.

Plan Actual

Sept orders 50 40
New orders 0 20 (for Sept)
Cancelled orders 0 10
Total orders 50 60

Your advice is appreciated.

Ray