I am creating a Grouped/Stacked Vertical bar using data imported from a spreadsheet. The spreadsheet has the data sorted as…