Home > Tracking Campaigns > Other Systems (CPVLab, iMobiTrax, P202, Track Revenue, Click, Google Analytics, etc.)

Google Data Studio: Bar Charts with Negative Values (1)


08-02-2017 05:21 PM #1 rolandb ()
Google Data Studio: Bar Charts with Negative Values

Fairly easy solution to stumble upon, but just in case people don't know..

I've been wanting to create a bar chart with negative values in Google Data Studio. Creating the default chart would result in the following:
Click image for larger version. 

Name:	1.jpg 
Views:	15 
Size:	43.8 KB 
ID:	16227

It uses 0 as the y-axis minimum (everything under Bar Chart Properties > Style), so the above is expected. You'd think the simple fix would be to just lower the y-axis to a negative value, but it then displays like so:
Click image for larger version. 

Name:	2.jpg 
Views:	10 
Size:	42.8 KB 
ID:	16228

So the bars now display from -infinity. The simple fix? Delete the y-axis min value so it becomes (auto). Now it looks like so:
Click image for larger version. 

Name:	3.jpg 
Views:	11 
Size:	39.4 KB 
ID:	16229

You lose some flexibility like if you want to put the axis in the middle of the chart. Data Studio still in beta after all.


Home > Tracking Campaigns > Other Systems (CPVLab, iMobiTrax, P202, Track Revenue, Click, Google Analytics, etc.)