Home |
Search |
Today's Posts |
#1
|
|||
|
|||
'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
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Scatter Graph - Data Label Problems | Charts and Charting in Excel | |||
Can you have a vertical line graph in Excel 2003 | Charts and Charting in Excel | |||
Bar graph values keep changing | Charts and Charting in Excel | |||
Problem with graph ranges | Charts and Charting in Excel | |||
Named dynamic ranges, copied worksheets and graph source data | Charts and Charting in Excel |