The easiest way to visually view information that shows profit or loss over time is to use a waterfall chart. You can create a waterfall chart in Microsoft Excel using the built-in charting tools, or you can create your own chart using a custom stacked bar chart.
How to Make a Waterfall Chart in Microsoft Excel
Follow the steps below to create a waterfall chart in Excel.
A waterfall chart is a diagram that shows the progression of a value over time or through successive stages. Simply put, a waterfall chart shows how things add up or subtract over time, so you can see the gains or losses you are making.
Each bar in the chart represents a separate element that positively or negatively affects the final total. Showing this data makes it easier to track how individual components contribute to a total.
