Hi Jeannine,
It sounds like you want a waterfall chart.
Go over to Jon Peltier's site and download his utility
http://peltiertech.com/Excel/Charts/...ive.html#Falls
Or take a look at my own, less conventional, way to do this at
http://edferrero.com/ExcelCharts/tabid/102/Default.aspx
(look for 'Waterfall Chart')
Ed Ferrero
www.edferrero.com