How to extract and display key data

Daniel 1 Reputation point
2022-09-25T00:46:38.01+00:00

I have a list of skills on the y-axis and a list of people on the x-axis. Skills are rated in three ranges.
Very good 7.9 - 10. I have formatting that highlights these cells in yellow.
Good 6 - 7.8. I have formatting that highlights these cells in blue.
Average 4 - 5.9. I have formatting that highlights these cells in pink

I would like to show the skills that the team has strength in and what they are weakest in. I have no idea how to do this graphically.

Thank you in advance :)

Danny.244542-screen-shot-2022-09-25-at-101503-am.png

Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,689 questions
{count} votes