![]() |
||
Questions? Call us 302-234-9857, 8AM to 10PM U.S. East Coast time 7 days a week |
||
|
|
||
The Waterfall Chart Creator allows you to create waterfall charts like the following:
On a waterfall chart the X axis represents a variable like units quantity or volume. The Y axis represents a unit rate like profit per unit or a percentage. If one were to multiply the X axis value times the Y axis value one gets a meaningful value. For example, profit per unit times units gives you profit. Thus the area for a data point represents this value. If you plot profit per unit versus volume for your customers on a waterfall chart then the shape of the data point's rectangle indicates the profitability of a customer. A tall, positive box indicates a very profitable customer. A short box with a long base indicates a customer who you are shipping a lot of product to who gives you very little profit. The Waterfall Chart Creator can also create multi-line waterfall charts:
In addition to constructing a waterfall chart from your data, the Waterfall Chart Creator can also label the charts. You have the option to not label any points, label all points, or to label only the large volume points. In addition, the following dialog allows you to re-arrange, rename, delete, or change the orientation of the labels.
To help you learn how to create waterfall charts the Waterfall Chart Creator comes with an example file with sample data. Step by step instructions are on each example page.
Customers who viewed the Waterfall Chart Creator also viewed:
|
|
| Copyright 2009 Add-ins.com LLC, all rights reserved. Spreadsheet Assistant is a registered trademark of Add-ins.com LLC. Microsoft, Excel and the Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries. |