![]() Cumulative data pointsĮach data point is shown in comparison to the data point immediately preceding it, with negative values in a different color from positive values.īelow is a waterfall chart of banking transactions which includes deposits and withdrawals, so both positive and negative values are shown. By showing only the difference between two data points at a time, waterfall charts highlight the changes between one date and the next. If you imagine each floating datapoint as extending all the way down to the X axis, the waterfall chart would simply be a cumulative column chart. The most noticeable feature of waterfall charts is their “floating” columns. Some distinctive features are discussed below. Waterfall charts look a bit unusual compared to the more common pie, bar, and line charts. Each subsequent value (with the exception of the final value - Total Sales) only highlights the difference between the previous value and the current. The chart above starts with the October 1 value (56 sales). ![]() The independent variables (dates) are shown on the horizontal axis, while the dependent variables (sales units) are shown on the vertical axis. The first seven values are shown in blue since they represent an increase in sales, as indicated by the legend. Once you understand that, we’ll graduate to a chart with both negative and positive values. While positive-only values are not typical of waterfall charts, this example is presented to show how the data is represented. In our first example, the source data is a table showing daily sales, so there are only positive values. However, they can also be applied in other settings such as sales, inventory, and education management to track and understand the effects of negative and positive values on cumulative performance. Waterfall charts have been typically used to track important values such as net profit or cash flow over time.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |