Tableau Line Chart is very useful to connect individual dots. We can use the line charts to check the trend in sales, Forecast details etc. In this article, we will show you, How to Create Line Chart in Tableau with an example. For this, we are going to use the Data Source we created in our previous article. So, Please visit Data Labels in Tableau Reports article to understand the Data Source.
Tableau Line Chart Example
In order 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, Sales Amount will be aggregated to default Sum. Once you drag them, Line Chart will be generated as we shown below.
If that is not the case, Please click on the Show Me tab, and select the Line chart.
Add Labels to Tableau Line Chart
Drag and Drop the Sales Amount from Measures Region to the Text field present in the Marks Shelf.
Now you can see the Sales Amount at each point
Tableau Line Chart using Multiple Measures
We can also create a line chart using the multiple measures. This can help us to compare the trend line of Sales, and Profit. In order 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 be aggregated to default Sum. Once you drag them, another Line Chart will be generated for product cost as we shown below.
Let us change the value from Year to All months present in each year to see the detailed monthly sales (trend)
Now you can see the detailed Line chart for each month present in 2011, 2012, 2013, and 2014
Create a Blended Axis Tableau Line Chart
To create a Blended axis in Tableau Line Chart, Please drag and drop the Total Product Cost from Row Shelf to Sales Amount axis as shown below
Following screenshot will show you the tableau Line Chart with the blended axis.
Create Dual Axis Tableau Line Chart
To create Tableau Dual Axis Line chart, Please select the Total Product Cost Axis and right-click on it will open the context menu. From that, Please select the Dual Axis option as shown below
Once you select the Dual Axis option following screenshot will be displayed. From the below screenshot you can observe that, We have Years in Horizontal Axis and Sales Amount, Total Product Cost in Vertical Axis (acting as Dual Axis)
We successfully created Dual Axes tableau report, but from the below screenshot you can observe that, we are unable to see the Sales Amount curve. This is because, The Maximum Axis values of Sales Amount is 1500K, where as 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
Following screenshot will show you the Tableau Line chart with Dual Axis
Thank You for Visiting Our Blog