#1   Report Post  
Ken Dog
 
Posts: n/a
Default '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?
  #2   Report Post  
Jon Peltier
 
Posts: n/a
Default

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?


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Scatter Graph - Data Label Problems TBD Charts and Charting in Excel 2 January 16th 05 05:08 PM
Can you have a vertical line graph in Excel 2003 smithers2002 Charts and Charting in Excel 3 January 12th 05 01:27 PM
Bar graph values keep changing Mike82j2000 Charts and Charting in Excel 1 January 6th 05 01:27 PM
Problem with graph ranges No Such Luck Charts and Charting in Excel 6 December 3rd 04 01:09 PM
Named dynamic ranges, copied worksheets and graph source data WP Charts and Charting in Excel 1 November 28th 04 05:19 PM


All times are GMT +1. The time now is 11:04 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"