Note: The other languages of the website are Google-translated. Back to English
Log in  \/ 
x
or
x
Register  \/ 
x

or

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.

v

Notes:

1. Click the Example button in the Horizontal Waterfall Chart dialog box will open the example workbook.
2. To change the size or color of mini chart, please browse the detail information in the example workbook.
3. For the series data, the last value should be the summary value of the list.

  If you want to have a free trial ( 30-day) of this utility, please click to download it, and then go to apply the operation according above steps.


Productivity Tools Recommended
The following tools can greatly save your time and money, which one is right for you?
Office Tab: Using handy tabs in your Office, as the way of Chrome, Firefox and New Internet Explorer.
Kutools for Excel: More than 300 Advanced Functions for Excel 2019, 2016, 2013, 2010, 2007 and Office 365.
Classic Menu for Office: Bring back familiar menus to Office 2007, 2010, 2013, 2016, 2019 and 365, as if it were Office 2000 and 2003.

Kutools for Excel

The functionality described above is just one of 300 powerful functions of Kutools for Excel.

Designed for Excel(Office) 2019, 2016, 2013, 2010, 2007 and Office 365. Free download and use for 60 days.

Screen shot of Kutools for Excel

btn read more      btn download     btn purchase