How to create a bridge chart in excel?

[Guest]

I need to create a bridge chart. The floating bar char might work but it
will not allow a bar to cross over 0 between negative and positive. Any help
will be appreciated!

 

[Jon Peltier]

Bill -

This is also called a waterfall chart, thought "bridge" is definitely
more descriptive. I have descriptions for waterfall charts, including
those that cross the horizontal axis:

http://peltiertech.com/Excel/Charts/Waterfall.html
http://peltiertech.com/Excel/Charts/waterfallcrossing.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______