How to make a source of change waterfall chart (Apple quarterly results)
In between the election news: waterfall charts….
Waterfall charts are a great tool to explain the difference between 2 scenarios. In SlideMagic, they are really easy to create. Below is one I put together quickly with data from Apple’s 2020 Q4 earnings result, and a photo I found using SlideMagic’s built-in Unsplash image search. Notice how I opted for an unusual vertical waterfall, to create more space for the axis labels.

Some people would argue that you could make the chart even clearer by breaking the axes: showing them as ‘5.6’ and ‘4.7’ for example. Yes, it would highlight the deltas better, but in general, I think manipulating axes, well, manipulates the message. The fact that the changes are relatively small to the total is part of the message.

I reshuffled the rows a bit to group the decreases and increases. That makes it more clear in one sense, but less clear in another. Your choice.
\How do you go about making such an analysis? I put my numbers in a Google Sheet that you can view yourself.
- Enter the data for the 2 comparable quarters in 2 columns. Add the totals as calculations rather than hard-coded numbers to check that you did not make any typos. (The blue cells are the one that I type in, the white ones are calculations).
- Create space between the 2 columns
- Pull numbers from the input that you consider drivers. You see that I deviated a bit from the way the input was presented:


















