Chapter 20: Getting Started with Excel Charts
20
Figure 20.36 shows a Pareto chart created from the data in range A2:B14. Notice that Excel
sorted the items in the chart. The line shows, for example, that approximately 50 percent
of all complaints are in the top three categories.The Pareto chart type is actually a Histogram subtype. You can find the Pareto chart type under Charts ➪ Insert
Statistic Chart.
FIGURE 20.36
A Pareto chart displays the number of complaints graphically.Waterfall charts
A waterfall chart is used to show the cumulative effect of a series of numbers, usually both
positive and negative numbers. The result is a staircase-like display. Waterfall charts were
introduced in Excel 2016.Figure 20.37 shows a waterfall chart that uses the data in column D. Waterfall charts
typically display the ending total as the last bar, with its origin at zero. To display the
total column correctly, select the column, right-click, and choose Set as Total from the
shortcut menu.