|
 |
        |
|
INDIVIDUAL PRODUCTS:
PRODUCT COLLECTIONS: |
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 water fall 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.
| |
| Copyright 2008 Add-ins.com LLC, all rights reserved. Spreadsheet Assistant is a registered trademark of Add-ins.com LLC. Microsoft and Excel are trademarks or registered trademarks of Microsoft Corporation. |
