Rounded bars are a feature that is sorely missed in Tableau. Though there are multiple workarounds to achieve rounded bars, most of these methods render the bar chart hard to read and inaccurate. Today, I’m going to guide you through the process of creating accurate bar charts with rounded ends.

The concept behind this technique is quite straightforward. Essentially, we add a shape to the end of the bar, giving it the appearance of a rounded bar chart. You can download the specific shape I use by clicking here. Once downloaded, place the PNG file into your Tableau repository shape folder, typically located at C:\Users\USERNAME\Documents\My Tableau Repository\Shapes.

Next, create the bar chart you want to use. Duplicate your measure to create a dual-axis chart, then change the type of your second marks card to ‘shape’. Select the rounded bar shape that you downloaded, and adjust the size to match your bars. Change the colour of the shape to match the background and Voila! You’re done.

You will need to add a dimension to the colour to change the colour of the shape, but this can be easily achieved with a min(0) on colour, followed by a right-click to make it discrete. Be cautious with the sizing, as the rounded shape that matches your bar chart on your sheet may not align perfectly on your dashboard. It might require some fine-tuning to achieve the right size, but once you do, the result will look fantastic. If you choose to create the shape yourself, ensure that the edge of the rounded shape is in the middle of the image, it will require some fiddling around to get right.

Samuel Goodman
Author: Samuel Goodman