How to create Overlapping Bars and a Line

Overlapping Bar

What may take you a couple of hours in Excel can be done in less than 2 minutes in Tableau. Learn how to create Overlapping Bars and a Line.  This is a method to visualize an Over Lapping Bar and also a line in the same graphic.

Follow these steps:

Step 1: Connect to data

In Tableau Desktop, connect to your data, in our case, it is Sample Coffee Chain.

Step 2: Create the visualization

Drag Date to Columns.

Set the Date as Discrete and choose the Date value you want. ( In our case, is Quarter – Year)

Drag Sales on the Axis.

Drag Budget Sales on top of the Sales Axis.

Right click on the Sales and Budget Sales Axis and choose from Mark Type – Bar.

→ Drag Inventory on the right Axis.

Drag Measure Names on size (on the Measure Values Mark).

Check from Analysis – Stack Marks to be OFF.

A #skillpill video by Alina Pătulea – Data Analyst @btProvider.

About btProvider:

We hold all possible technical and sales certifications for all products: Tableau Desktop, Tableau Public, Tableau Server, Tableau Prep, Tableau Data Management.

With Tableau Software – the best data visualization platform – you can always understand your business or your job better. Using Tableau, you will take smart and strategic decisions and you will quickly understand the data flow, numbers and results it produces.

Are you interested in learning more about Tableau Software – one of the best analytics tools and implementing the solution in the entire company? Contact us!

See how Tableau works, by downloading a free trial here: