How to Create Stacked Combo Charts that Display Negative Numbers in Google Data Studio

A step-by-step tutorial for creating negative value custom fields, using SEMrush’s Data Studio connector and Backlinks History data.

You have some beautiful data, showing loss and gain of the same dimension.

Typically such data is recorded and kept into two separate fields — one showing the loss and the other the gain. Ideally, you’d have one for totals as well.

How can you illustrate this beautifully in Google Data Studio? While there are many ways of doing this, a good one is through a stacked combo chart.

The best way is by illustrating the losses as negative bars below the axes.

That is what this tutorial will show.

1. Connect your data.

Use the SEMrush Data studio connector to import the Backlinks History data to a stacked combo chart.

To import the backlinks history, go to the SEMrush Domain Analytics.

Screencapture by author

Then, select the Backlinks: History report type.