Tutorial Gateway

  • C
  • C#
  • Java
  • Python
  • SQL
  • MySQL
  • Js
  • BI Tools
    • Informatica
    • Talend
    • Tableau
    • Power BI
    • SSIS
    • SSRS
    • SSAS
    • MDX
    • R Tutorial
    • Alteryx
    • QlikView
  • More
    • C Programs
    • C++ Programs
    • Python Programs
    • Java Programs

Dual Lines Chart in Tableau

by suresh

The Tableau Dual Lines Chart is useful to compare 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 are going to 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 Measures Region to Rows Shelf. Because it is a Measure value, the Sales Amount aggregated to default Sum. Once you drag them, Bar Chart will generate.

Dual Lines Chart in Tableau 2

Next, Drag and Drop Order Date from Dimensions Region to Columns Shelf. Once you drag the Order Date, 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 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 Measures Region to Rows Shelf. Since it is a Measure value, Total product Sale aggregated to 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 from it

Dual Lines Chart in Tableau 9

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

Dual Lines Chart in Tableau 10

If you have no problem, Leave 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, Please click on 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

Placed Under: Tableau

  • Download and Install Tableau
  • Tableau Start Page
  • Tableau Show Me
  • Connect to MS Analysis Services
  • Connecting Tableau to SQL
  • Tableau Connect to Text File
  • Tableau Connect to Excel File
  • Hierarchies in Tableau
  • Tableau Bins
  • Tableau Parameters
  • Combined Tableau Sets
  • Tableau Set
  • How to Edit Tableau Group
  • Tableau Group
  • Tableau Grouping
  • Tableau First Report
  • Data Labels in Tableau Reports
  • Format Tableau Chart Title
  • Create Folders in Tableau
  • Tableau Sort
  • Add Totals in Tableau
  • How to Join Data in Tableau
  • Tableau Data Blending
  • Tableau Table Report
  • Tableau Crosstab Report
  • Tableau Annotations
  • Tableau Charts
  • Tableau Area Chart
  • Tableau Bar chart
  • Tableau Box Plot
  • Tableau Bubble Chart
  • Tableau Bullet Graph
  • Tableau Bump Chart
  • Tableau Circle Views
  • Tableau Dual Combination Chart
  • Tableau Dual Lines Chart
  • Tableau Funnel Chart
  • Tableau Traditional Funnel Chart
  • Tableau Gantt Chart
  • Tableau Grouped Bar Chart
  • Tableau Heat Map
  • Tableau Highlight Table
  • Tableau Histogram
  • Tableau Cumulative Histogram
  • Tableau Line Chart
  • Tableau Lollipop Chart
  • Tableau Pareto Chart
  • Tableau Pie Chart
  • Tableau Scatter Plot
  • Tableau Stacked Bar Chart
  • Tableau Text Label
  • Tableau Treemap
  • Tableau Word Cloud
  • Tableau Waterfall Chart
  • Tableau Individual Axis
  • Tableau Dual Axis
  • Tableau Blended Axis
  • Tableau Add Reference Lines
  • Tableau Add Reference Bands
  • Add Reference Distributions
  • Tableau Maps
  • How to Create a Map in Tableau
  • Use Google Maps in Tableau
  • Mapbox Maps as a Background
  • WMS Server Map as Background
  • Create a Tableau Dashboard
  • Format Dashboard Layout
  • Create Dashboard Device Prev
  • Tableau Dashboard Objects
  • Create a Tableau Story
  • Tableau Filters
  • Tableau Filters on Dimensions
  • Tableau Filters on Measures
  • Tableau Extract Filters
  • Tableau Dashboard Filters
  • Tableau Data Source Filters
  • Tableau Slicing Filters
  • Tableau Quick Filters
  • Tableau Context Filters
  • Tableau Top Filters
  • Tableau Table Calculations
  • Tableau Calculated Fields
  • Tableau Running Total
  • Tableau Rank Calculation Basic
  • Tableau Rank advanced calculate
  • Tableau Aggregate Functions
  • Tableau Conversion Functions
  • Tableau Case Function
  • Tableau Date Functions
  • Tableau If Function
  • Tableau Logical Functions
  • Tableau Math Functions
  • Tableau String Functions
  • Tableau Table Functions
  • C Tutorial
  • C# Tutorial
  • Java Tutorial
  • JavaScript Tutorial
  • Python Tutorial
  • MySQL Tutorial
  • SQL Server Tutorial
  • R Tutorial
  • Power BI Tutorial
  • Tableau Tutorial
  • SSIS Tutorial
  • SSRS Tutorial
  • Informatica Tutorial
  • Talend Tutorial
  • C Programs
  • C++ Programs
  • Java Programs
  • Python Programs
  • MDX Tutorial
  • SSAS Tutorial
  • QlikView Tutorial

Copyright © 2021 | Tutorial Gateway· All Rights Reserved by Suresh

Home | About Us | Contact Us | Privacy Policy