Tableau Line Chart is valuable for connecting individual dots. We can use the line charts to check sales trends, Forecast details, etc. Let us see how to create a Line Chart with an example.
For the Tableau Line Chart demo, we use the data source we built in our previous article. So, visit Data Labels in 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 the Measures Region to the Rows Shelf. Since it is a Measure value, the Sales Amount is aggregated to the default Sum. Once you drag them, the below report will generate.
If that is not the case, please click on the Show Me tab, and select the shown option.
Add Labels to Tableau Line Chart
Drag and release the Sales Amount from the Measures Region to the Text field in the Marks Shelf.
Now you can see the Sales Amount at each point
Tableau Line Chart using Multiple Measures
We can also create this using multiple measures. It can help us to compare the trend line of Sales and Profit. To create a Line Chart First, Drag and Drop the Total product Sale from the Measures Region to the Rows Shelf. Since it is a Measure value, Total product Sales will aggregate to the default Sum. Once you drag them, another one will generate the product cost.
Let us change the value from Year to All months present in each year to see the detailed monthly sales (trend)
You can see the detailed strip for each month in 2011, 2012, 2013, and 2014 in the Tableau line chart.
Create a Blended Axis Line plot
To create a Blended axis strip, Please drag and drop the Product Cost from the Row Shelf to the Sales Amount axis, as shown below.
The following screenshot shows you the Line Chart with the blended axis.
Create a Tableau Dual Axis Line Chart
To create a Dual Axis strip, 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.
Once you choose the Dual Axis option following Tableau line chart screenshot will be displayed. From the below image, you can observe that we have Years on the Horizontal Axis and Sales Amount, Total Product Cost on Vertical Axis (acting as Dual Axis)
We successfully created the Dual Axes report. But from the below screenshot, you can see we are unable to see the Sales Amount curve. Because the Maximum Axis value of the Sales Amount is 1500K, whereas the Total Product Cost is 1000K. 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.
The below screenshot will show you the Tableau Line chart with Dual Axis.
