Chart for Library Student Occupency Chart

I have study library of 70 seating capacity. All data is only in this sheet. I want to create a chart in which I get libraray seat occupancy status by colour. Whenever seat is occupied then Green co...