• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

How to extract and display key data

dgm2603@

New Member
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.
 

Attachments

p45cal

Well-Known Member
In the attached, 2 copies of your sheet.
On sheet Strengths is a Power Query query on your table output to a Pivot table and chart.
If you don't have Power Query you can do the same thing by adding a column to your table being an average of the scores on that row. See column V on the Strengths (2) sheet. Columns B and V are plotted on the chart and the data is sorted by column V.
 

Attachments

afransami

New Member
In the attached, 2 copies of your sheet.
On sheet Strengths is a Power Query query on your table output to a Pivot table and chart.
If you don't have Power Query you can do the same thing by adding a column to your table being an average of the scores on that row. See column V on the Strengths (2) sheet. Columns B and V are plotted on the chart and the data is sorted by column V.
Hey @p45cal , Definitely you did good work. I appreciate your afford. Could you show me that from another view, please?
I would love to see the chart from the individual's corner.

Could you provide this, lease? So that we could learn both.
 
Top