Category Archives: Data Visualization

How to customize bar colors in a waterfall chart in Google Sheets

Waterfall chart is a good way to show changes overtime. One good example is showing how business revenue is growing in different components over a certain period so that you can have an overview of growth drivers.

Here is a use case where I want to illustrate how ARR is growing in the past year and the formula is very straightforward:

Continue reading

ggplot2 Theme Elements Demonstration

ggplot2 is one of the most powerful packages in r for data visualizations and it is essential to master the underlying grammar of graphics to fully utilize its power. While the theming system of ggplot2 allows you to customize the appearance of the plot according to our needs in practice, it is always a frustration to identify the elements on the plot you want to change as you may find it difficult to remember the element names and their corresponding functions to modify, at least this is the case for me.

Continue reading