> For the complete documentation index, see [llms.txt](https://docs.infotopics.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.infotopics.com/showmemore/features/waterfall-chart/format.md).

# Format

### Format aggregation and total

<figure><img src="/files/ywcOxeIVqz5zjYLWn8pB" alt="" width="375"><figcaption><p>Waterfall Chart configuration panel -> Format</p></figcaption></figure>

#### Aggregate first category to a total

Total your first category by aggregating. This will give you your starting point to run through the series. This could be the total of the previous years sales to then compare to the current year. If you want to just see the progressive sales from the start, show all values with a separate total.

#### Show cumulative values

Here you have the options to show cumulative values of your dimension through your series of dimensions or to compare the values in the series to the previous category. You may need insight over one series of which products or departments are performing well or may need to see how those performed compared to the series before. Both possible here.

#### Options for totals

Choose how totals are displayed in the Waterfall chart.

**Show total at the end of every category**\
Displays a total bar after each category in the Waterfall chart.

**No, show no totals**\
Hides all total bars from the Waterfall chart.

**Choose which categories show totals**\
Allows you to select specific categories where a total bar should be displayed.\
When this option is selected, the **Categories with totals** list appears. Select the categories that should include a total bar.

<figure><img src="/files/bioPOOkecx4OuhGt91GA" alt="" width="375"><figcaption></figcaption></figure>

#### Y-Axis min (%)

Y-Axis Min (%) – if set, the minimum value of the y-axis will be set from the specified percentage of the first category (first bar in the chart).. Configuring the Y axis to start at your specified level will allow you to focus on each value of your Waterfall Chart.

<figure><img src="/files/JbWgKnjTymZx6jeFfnAB" alt=""><figcaption></figcaption></figure>

#### Bar width

Use this setting to make the bars narrower or wider to improve readability and fit the chart layout.

#### Show labels/X-axis/Y-axis

Show or hide your measure labels in your viz. Turn off the X and Y axis too.

#### Show growth percentages

A very useful feature of the Waterfall Chart is the growth percentages shown at the top of each dimension. Each is This can be shown or hidden if you just want the bar charts to show you the differences.

#### Rotate X-axis label

Use the scroll bar to rotate the labels of your dimensions. Get your waterfall chart looking just how you want it.

#### X-axis & Y-axis spacing

Condense or spread out the waterfall chart for a clearer chart or to save that valuable dashboard space&#x20;

<br>


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## 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, and the optional `goal` query parameter:

```
GET https://docs.infotopics.com/showmemore/features/waterfall-chart/format.md?ask=<question>&goal=<endgoal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal.

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.
