Challenge #318: My first dog

[AYXAcademy]

A solution to last week’s challenge can be found here. 

John has decided that it's time to adopt a dog. However, he has never owned a pet before. He is having trouble deciding on which furry friend would be best.

Your challenge is to help John make a choice.

You will use three datasets that contain all the information needed for the research.
The ranking for each criterion goes from 1 (low/not good) to 5 (high/excellent).

John wants a dog that would suit his lifestyle best, and here are the most important criteria.
A small dog that will adapt easily to living in an apartment and doesn't bark too much, as neighbors would complain if barking is excessive. Since John is a novice owner, the dog needs to be easy to train and friendly with strangers.

Use these five criteria to select three dogs. Then create a report showing your findings and help John make his decision.

Following our users' comments, this Weekly Challenge has been updated. Thank you for your participation.

[Aaron_Harter]

Lots of great dog breeds on the list!

Spoiler

Pyredoodles are missing from this list, but they are amazing:

[patrick_digan]

Spoiler

[alexnajm]

Good challenge... although I would argue my three breeds are correct.

Spoiler

[RolandSchubert]

Spoiler

Spoiler

[dbrownsc]

Fun challenge this week! My selected breeds look slightly different, but I'm comfortable with my answer. 

[dYoast]

John needs to move to a house with a yard.

I ended up with one different breed.

Spoiler

[Luke_C]

Spoiler

[Kenda]

Spoiler

I'm with @alexnajm I would switch up one of the top 3 dogs on the list according to these stats

[phottovy]

My solution:

Spoiler

I'm a little rusty with the chart tool. Is there way to transpose the data and use the column names as the colors instead of adding individual layers for each?