Create Excel waterfall charts easily

Waterfall Chart Creator in detail

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.

See also in "Excel - Chart creation and management"

• Cascade Chart Creator - Create Cascade Charts in Excel.
• Chart Assistant - Easily create hundreds of Excel charts.
• Chart Labeler - Easily label and re-arrange your Excel chart points.
• Chart Viewer - A full screen Excel charts slide show.
• Histogram Creator - Create presentation quality Excel histograms.
• Quick Chart Creator - Use one Excel chart for many rows of data.