Stacked Bar Chart (Sales per month) with Total Line (Method 1)

1.    Drag Order Date into columns and select month.

2.    Drag Sales into row.

3.    Drag category into Color.

4.    Select marks card as Bar.

5.    Now you get a Stacked bar chart.

6.    Now duplicate Sales in the row.

7.    Select line in the marks card for the duplicated Sales.

8.    Remove Category from Color in duplicated Sales.

9.    Drag Sales on Label.

10.  Click on dual axis on Sales.

11.  Click on Synchronize the Axis y-axis (vertical) and then click on Show header to hide the axis.

12.  Click on Entire View.

 

Related Topics

Steps to Create Various Visuals


Copyright (c) 2022 Clario. All Rights Reserved.