How to extract and display key data

Question

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.

Answer 1

Hi,

First and foremost, transform your data into a 3 column one - Name, Skills and Values. This can be done using the "Unpivot Other Columns" feature in Power Query. Once done, create a Pivot Table and a Pivot chart from there.

Hope this helps.