> For the complete documentation index, see [llms.txt](https://books-gyansetu.gitbook.io/advanced-excel/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://books-gyansetu.gitbook.io/advanced-excel/charts-waterfall-graph.md).

# Charts, Waterfall Graph

**Introduction**

It can often be difficult to interpret Excel workbooks that contain a lot of data. **Charts** allow you to illustrate your workbook data **graphically,** which makes it easy to visualize **comparisons** and **trends**.

![](https://2721809844-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LR_tHSREe3Wm40fY9NG%2F-LRwgZ8BGUWQKxnd8bAm%2F-LRwhI5dxUttg8W4-g1E%2Fimage.png?alt=media\&token=bf9a7596-519a-4b58-a452-9ad1f4edbf4e)

**Different type of Charts**

![](https://2721809844-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LR_tHSREe3Wm40fY9NG%2F-LRwgZ8BGUWQKxnd8bAm%2F-LRwhh33cLM80y4dZ9MN%2Fimage.png?alt=media\&token=2dd21652-278b-4c21-8135-fe86d071a94e)

**Create an Excel Waterfall Chart**

You can use an Excel Waterfall chart to show the cumulative effect of positive and negative amounts, based on a starting value. For example, show the monthly net cash flow amounts in a waterfall chart, and quickly see which months had positive and negative results.

Refer the Attached Sheet.

{% file src="/files/-LRwiT\_tGI\_muY4lnR2U" %}
Waterfall Chart Example
{% endfile %}