Dual Lines Chart in Tableau

The Tableau Dual Lines Chart is useful for comparing the trend of multiple measures visually. In this article, we will show you how to create a Dual Lines Chart in Tableau with an example.

For this Tableau Dual Lines Chart demo, we will use the Data Source we created in our previous article. Please visit Data Labels in Tableau Reports article in Tableau to understand the Data Source.

Dual Lines Chart in Tableau 1

Dual Lines Chart in Tableau Example

To create the Tableau Dual lines Chart, First, Drag and Drop the Sales Amount from the Measures Region to the Rows Shelf. Because it is a Measure value, the Sales Amount is aggregated to the default Sum.

Once you drag them, a Bar Chart will generate.

Dual Lines Chart in Tableau 2

Next, Drag and Drop the Order Date from the Dimensions Region to Columns Shelf. Once you drag the Order Date, a Line Chart will generate.

Dual Lines Chart in Tableau 3

Let me change the Order date value from Year to All months present in each year to see the detailed monthly information (trend line)

Dual Lines Chart in Tableau 4

Now you can see the detailed Line chart for each month in 2014, 2015, 2016, 2017, and 2018

Dual Lines Chart in Tableau 5

Create a Dual Lines Chart Approach 1

There are multiple ways to create a Dual Lines chart in Tableau. Drag and Drop the Total product Cost from the Measures Region to a right-side axis.

Dual Lines Chart in Tableau 6

This will automatically create a Dual Lines chart for you

Dual Lines Chart in Tableau 7

Create a Dual Lines Chart in Tableau Approach 2

Let me undo the above step. Next, Drag and Drop the Total product Cost from the Measures Region to the Rows Shelf. Since it is a Measure value, the Total product Sale aggregated to the default Sum. Once you drag them, another Line Chart will be generated for Total product cost, as we showed below.

Dual Lines Chart in Tableau 8

Let me change this to the Dual Lines chart. To do so, Please expand the Show Me window and select the Dual Lines Chart.

Dual Lines Chart in Tableau 9

The Dual Lines Chart will be displayed once you choose the Dual Lines from the Show Me window. Though it looks good from the below screenshot, you can observe that the Maximum Axis values of the Sales Amount are 1500K, whereas Total Product Cost is 1000K.

Dual Lines Chart in Tableau 10

If you have no problem, Leave it as it is; otherwise, Please select the Total Product Cost and select the Synchronize Axis.. option from the context menu.

Dual Lines Chart in Tableau 11

Now you can see the Dual Lines Chart with Synchronized Axis. You can also remove one axis.

Dual Lines Chart in Tableau 12

Add Data labels to Dual Lines Chart

To add data labels to the Dual Lines chart, click the Show Mark Labels button in the Toolbar. Though it looks odd, you get the idea of adding data labels.

Dual Lines Chart in Tableau 13

Add Forecast to Dual Lines Chart in Tableau

Drag and drop the Forecast from the Analytics tab to the Dual Lines chart.

Dual Lines Chart in Tableau 14

Now you can see the forecast as well.

Dual Lines Chart in Tableau 15

Also, refer to the Change the Line Chart Color and Change the Size of a Line Chart articles to understand the options.