'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? |
All times are GMT +1. The time now is 07:22 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com