A Waterfall Chart graphically illustrates the cumulative effect of sequentially introducing positive or negative values to an initial value. It is normally used to visualize how an initial value is affected by a series of intermediate positive or negative values. The initial and final (or total) values are represented by whole columns drawn from the category/X-Axis baseline. Intermediate positive and negative values are drawn as floating columns. The columns are typically color coded to distinguish between positive (green) and negative (red) values.
A Waterfall Chart is also known as a Cascade Chart which is often used in Financial statements as a visual form of cash-flow analysis.
The Three D Graphics Waterfall Chart component is an Xcelsius add-on component that can be used to introduce Waterfall Charts in an Xcelsius report. In addition to the standard Waterfall Chart functionality, the Three D Graphics component includes:
- Multiple Subtotal risers
- Multiple Intermediate "Other" risers that can be color-coded independent of the green/red positive/negative risers
- By default the Total riser is auto-calculated based on passed-in cells (values). A Custom Total value can be specified to replace the normal automatic calculation.
- Automatic or Manual Y-Axis scaling
- Zero-based or Non-Zero-based Automatic Y-Axis scaling
- Riser Width and Connector Line controls
- Color and Transparency controls for risers, plot area, and chart area
- Drop Shadows on risers
- Color, Transparency, and Width controls for grid lines, ticks, and axis lines
- Data Text Position Controls. The default settings place data text below negative risers, above positive risers, and in the center of total/subtotal risers. These default setting can be changed with the Data Text Position controls.
- Automatic adjustment of data text labels so they are most visible depending on the size of a riser. If a riser is set to "center" and the data text label does not fit, auto-adjust will move the label to above/below the riser.
- Dynamic Visibility: Dynamically show/hide the Waterfall Chart component based on a field in the data set.
Three D Graphics |