Tableau Line Chart

Tableau Line Chart is valuable to connect individual dots. We can use the line charts to check the trend in sales, Forecast details, etc. Let us see how to create a Line Chart in Tableau with an example.

For Tableau Line Chart demo, we use the Data Source that we built in our previous article. So, visit Data Labels in Tableau Reports article to know the Tableau Data Source.

Tableau Line Chart Example

To create a Tableau Line Chart First, Drag and Drop the Year from Dimension Region to Column Shelf. Next, Drag and Drop the Sales Amount from Measures Region to Rows Shelf. Since it is a Measure value, the Sales Amount aggregated to default Sum. Once you drag them, Line Chart will generate.

Tableau Line Chart 1

If that is not the case, please click on the Show Me tab, and select the Line chart.

Tableau Line Chart 2

Add Labels to Line Chart

Drag and release the Sales Amount from Measures Region to the Text field present in the Marks Shelf.

Tableau Line Chart 3

Now you can see the Sales Amount at each point

Tableau Line Chart 4

Tableau Line Chart using Multiple Measures

We can also create a line chart using multiple measures. It can help us to compare the trend line of Sales and Profit. To create a Tableau Line Chart First, Drag and Drop the Total product Sale from Measures Region to Rows Shelf. Since it is a Measure value, Total product Sale will aggregate to default Sum. Once you drag them, another Line Chart will generate for the product cost.

Tableau Line Chart 5

Let us change the value from Year to All months present in each year to see the detailed monthly sales (trend)

Tableau Line Chart 6

Now you can see the detailed Line chart for each month in 2011, 2012, 2013, and 2014

Tableau Line Chart 7

Create a Blended Axis Tableau Line Chart

To create a Blended axis Line Chart, Please drag and drop the Product Cost from Row Shelf to Sales Amount axis as shown below

Tableau Line Chart 8

The following screenshot shows you the Line Chart with the blended axis.

Tableau Line Chart 9

Create a Dual Axis Tableau Line Chart

To create a Tableau Dual Axis Line chart, Please select the Total Product Cost Axis and right-click on it will open the contextual menu. From that, Please select the Dual Axis option as shown below

Tableau Line Chart 10

Once you choose the Dual Axis option following screenshot will be displayed. From the below image, you can observe that we have Years in Horizontal Axis and Sales Amount, Total Product Cost in Vertical Axis (acting as Dual Axis)

Tableau Line Chart 11

We successfully created the Dual Axes tableau report. But from the below screenshot, you can see we are unable to see the Sales Amount curve. Because the Maximum Axis values of the Sales Amount is 1500K, whereas Total Product Cost is 1000K. 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

Tableau Line Chart 12

The below screenshot will show you the Line chart with Dual Axis

Tableau Line Chart 13