Cleanest way to make a graph

Hi!

I hope this makes sense. I am trying to find the best way to represent several kpis in one graph. I have been trying a couple of things but am running out of ideas to represent what I need to represent. Most of the times I being told that there is too much info on my slide.

So the idea is that we have personnel, equipment and vehicle evaluated against different criteria. 1) is it available/serviceable 2) number available meets the minimum number requs 3) needs to show if it's limited capacity (does not count towards meeting the min req) 3) if it's already assigned to a task, this counts towards meeting the minimum but it needs to be accounted/shown separately.

Originally I had a table, then was told I needed to make a graph.

So I made a graph with 3 columns.

If # was meeting min it would show in light green, excedents would show in dark green, if it's limited capacity, it would show in orange and if it exists but is already assigned to a task, it's in blue. There is a legend that provides minimum required for personnel, equiment and vehicle. That number is different for each category. My team thinks its too complicated and could be simplified. I am not an excel guru, so any help, hint or example is really appreciated. Ideally, I would also like to make a small legend highlighting the criteria to be accounted for (holding 2 specific quals, have the 2 pieces of the equipment, vehicle is inspected), maybe in a way that's organicallu included in the graph.

Thank you!