Multiple charts of clustered columns for multiple entries in a spreadsheet

Solution 1:

I think you need the Excel Power Query to unpivot your data first.

Step 1, Select your dara range > Right-click it > Get Data from Table/Range.

enter image description here

Step 2, select 2 columns, Delivered and Collected > Right-click > Unpivot Columns.

enter image description here

Step 3, close and load this query, then create a pivot table as following.

enter image description here

Step 4, right-click the data value in pivot table > Group > Choose by Months and Years.

enter image description here

Step 5, crteat the pivot table chart. You may choose different location via filter.

enter image description here