Easily create a horizontal waterfall chart in Excel

Normally, you can create a vertical waterfall chart quickly in Excel. Here recommend the Horizontal Waterfall Chart utility of Kutools for Excel. With this feature, you can easily create a horizontal waterfall chart or a mini horizontal waterfall chart in Excel.

Create a horizontal waterfall chart

You can do as follows to create a horizontal waterfall chart in Excel.

1. Click Kutools > Charts > Difference Comparison > Horizontal Waterfall Chart.

2. In the Horizontal Waterfall Chart dialog box, configure as follows.

2.1) In the Chart type section, choose the Chart option;

2.2) In the Select Data section:

Axis Labels: Select the axis labels data range;

Data range: Select the series data range.

2.3) Click OK.

3. A Kutools for Excel dialog box pops up, click Yes.

And then a horizontal waterfall chart is created as the below screenshot shown.

Create a mini horizontal waterfall chart

This feature can also help to create a mini horizontal waterfall chart in Excel cells. You can do as follows to get it done.

1. Click Kutools > Charts > Difference Comparison > Horizontal Waterfall Chart.

2. In the Horizontal Waterfall Chart dialog box, do the following settings.

2.1) In the Chart type section, choose the Mini chart option;

2.2) In the Mini Chart Options section, there are two options “Add a category name label” and “Add a series value label”, it’s optional to choose one of them, both of them, or none as you need;

2.3) In the Select Data section:

Axis Labels: Select the axis labels data range;

Data range: Select the series data range.

2.4) Click OK.

3. In the opening Kutools for Excel dialog box, click Yes.

4. Then a Select data dialog box pops up, select a cell to output the mini chart, and then click OK.

Now a mini horizontal waterfall chart is created.

When choose both the “Add a category name label” and “Add a series value label” options in the Horizontal Waterfall Chart dialog box, you will get the mini chart as follows.

When none of them are chosen, you will get the mini chart as the below screenshot shown.

When choose one of them such as “Add a series value label”, you will get the result as follows.

Notes:

Productivity Tools Recommended

Office Tab: Use handy tabs in Microsoft Office, just like Chrome, Firefox, and the new Edge browser. Easily switch between documents with tabs — no more cluttered windows. Know more...

Kutools for Outlook: Kutools for Outlook offers 100+ powerful features for Microsoft Outlook 2010–2024 (and later versions), as well as Microsoft 365, helping you simplify email management and boost productivity. Know more...

---

Kutools for Excel

Kutools for Excel offers 300+ advanced features to streamline your work in Excel 2010 – 2024 and Microsoft 365. The feature above is just one of many time-saving tools included.

🌍 Supports 40+ interface languages

✅ Trusted by 500,000+ users and 80,000+ businesses worldwide

🚀 Compatible with all modern Excel versions

🎁 30-day full-featured trial — no registration, no limitations

Try It Now!See PricingUnlock Full Features