Cascade Chart Creator

A charting add-in product for Microsoft Excel

Do you have these problems:

• Confused about how to create a cascade chart?
• Want to make your cascade charts more professional?
• Need to create a chart that crosses the x axis?

The Cascade Chart Creator can solve all of these problems and more!

The Cascade Chart Creator allows you to create cascade charts like the following:

You can also create cascade charts like the following:

See Enlarged Screenshots by clicking More Images above

On a cascade chart the height of the red and green boxes represents the amount of change due to an explanation which is listed below the box on the X axis.  The value of the boxes can be shown in the middle, at the top, or at the bottom of the box.  Such charts are an excellent way to explain change.

The Cascade Chart Creator is totally menu driven.  To create a cascade chart there are two approaches:

• You can specify the cells (in rows or columns) containing the values to be plotted
• Or you can enter your values into an input form and have a chart and a table of data created.

With either approach you can plot as many data points as you want.  And you can delete points if you don't need them. You can have multiple total values in a chart not just totals at the end points.  And if you do not plot the totals you can create a brickyard style cascade chart like the last example above.

Click on the following thumbnails to see the Cascade Chart Creator's formatting and other options menus.   These menus allow you to specify colors, solid or gradient fill, show values and position, and many other options:

See Enlarged Screenshots by clicking More Images above

You may send cascade charts you create with the Cascade Chart Creator to others.  They do not need the Cascade Chart Creator add-in to view the charts.

The following are a list of just some of the features:

• Use solid colors, one color gradient, or two color gradient fills - new in version 3
• Use any pattern for files - new in version 3
• Create multiple cascade charts at one time - new in version 3
• Update multiple cascade charts at one time - new in version 3
• Hide or show any part of the axes or the chart - new in version 3
• Change multiple cascade charts at one time - new in version 3
• Choose any color for total columns and cascade values
• Easily update and modify charts
• Select any destination for new charts
• Easily display values on the chart - top bottom or middle locations
• Total columns in between start and end values can have different formatting than the start and end columns
• Specify a Y axis minimum to eliminate charts with tall columns and small cascade values.
• Save up to 10 chart settings
• Customize the default chart setting and colors for new charts
• Create "brickyard" charts like the last example on the right
• Insert gaps between values
• Show multiple cascade plots on one graph