Simple Tableau Dual Line Chart
Drag Discount to the right side of the Profit Ratio chart.
Tableau dual line chart. Line Chart Dual Axis with Dot. To draw a dual lines chart you have to select minimum of three attributes by drag and drop into a row then apply the other parameter for better visualization. Keep in mind its especially useful for an Executive Dashboard that shows a.
Line Chart Dual Axis with Bar. Right-click on the second SUM Sales measure on Rows and select Dual Axis Right-click the axis to the right of the view and select Synchronize Axis Select SUM Sales 2 on the Marks card Drag Category to Color. If you want to add 3 or more measures to a line chart you need to take a different approach than in regular charts.
Overlay The Lines With A Dual Axis. On the Marks card select the axis colored by sales. This will automatically create a Dual Lines chart for you.
Also on the Color box select 65 on the Transparency slider. The Percentage field has our ethnicity percentages by year in it so we can just add that to rows change the chart type to a line remove Measure Values from colour and create a dual axis by right-clicking SUMPercentage. Create a Dual Lines Chart in Tableau Approach 2.
Now we want to add a seconds row that contains Profit Ratio and Discount. The result is a dual-axis chart. Drag and Drop the Total product Cost from Measures Region to a right-side axis.
In previous parts we delved into the dual axis line charts which are combined with line dot and area. I then created a Dual Axis with the relevant measure Bar Chart is Sales Map is Latitude. All thats left to do now is to add the lines.