"Total" row of a table isn't displayed in waterfall charts in Excel 2016

Symptoms
After you create a waterfall chart for a table that contains a "total" row and also contains a column of positive and negative numbers in Microsoft Excel 2016, the total isn't displayed in the waterfall chart.
Workaround
To work around this issue, use one of the following methods:
  • Copy the table, paste the values of the table to a new location, and then create a new waterfall chart by using the copied data.
  • Convert the table back to a normal range by using the Convert to Range function, and then create a waterfall from the range.
More information
Waterfall charts are new in Excel 2016. They show the cumulative effect of sequentially introduced positive or negative values. Waterfall charts are also known as a flying brick charts, bridge charts, or Mario charts because of the apparent suspension of columns (bricks) in midair. Waterfall charts are mainly used in the financial industry but also in other industries where it's important to report and visualize resource consumption.
Status
Microsoft has confirmed this to be a problem in Excel 2016. We are researching this problem and will post new information in this Microsoft Knowledge Base article as soon as the information becomes available.
Waterfall totals chart kbproblem
Свойства

ИД на статията: 3092175 – Последен преглед: 09/23/2015 03:10:00 – Редакция: 2.0

Excel 2016

  • kbqfe kbsurveynew kbexpertisebeginner kbbug kbtshoot kbfix KB3092175
Обратна връзка