'Canyon' Graph

A canyon graph is an awesome tool to demonstrate the costs versus benifits of
a project. It starts at the $0 line, assuming the project is not done.
Then, the canyon makes steps down, proportional to the costs. When all the
costs are included, then the benefits are added, with largest benefits first.
Would like to do this in excel, instead of drawing one manually. Is there
an add on, or a template?

Ken -

Here are a couple pages to help you get started:

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

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

Ken Dog wrote:

> A canyon graph is an awesome tool to demonstrate the costs versus benifits of
> a project. It starts at the $0 line, assuming the project is not done.
> Then, the canyon makes steps down, proportional to the costs. When all the
> costs are included, then the benefits are added, with largest benefits first.
> Would like to do this in excel, instead of drawing one manually. Is there
> an add on, or a template?