Bar in Bar Chart (Method 1)

1.    Drag Sub-categories to Rows.

2.    Drag Sales to Columns.

3.    Drag Order Date (Year) to Color.

4.    Select Descending.

5.    On Year legend (right side corner) exclude 2015 and 2016 and switch 2017 and 2018 (by placing 2018 on top and 2017 underneath it).

6.    Hold Ctrl and drag Order Date to Size and reduce the size to medium.

7.    Click on Analysis menu and then Click on Stack marks and Tick off.


 

Related Topics

Steps to Create Various Visuals


Copyright (c) 2022 Clario. All Rights Reserved.