# 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="<https://2721809844-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LR_tHSREe3Wm40fY9NG%2F-LRwgZ8BGUWQKxnd8bAm%2F-LRwiT_tGI_muY4lnR2U%2Fwaterfall%20graph.xlsx?alt=media&token=d0bfc06f-d357-4058-8434-8752d8b08317>" %}
Waterfall Chart Example
{% endfile %}


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://books-gyansetu.gitbook.io/advanced-excel/charts-waterfall-graph.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.