r/dataisbeautiful 2d ago

OC [OC] Overall ranking for 51+ Countries

Post image

My sheets document includes the sources, but the ranking uses 13 different sources. Sadly, not every country is included in every source so you will see blank spaces for countries that are left out in the data. I've also created a correlation index to see how different metrics matched up with each other and you can see the data I used for each ranking.

https://docs.google.com/spreadsheets/d/1YbfVevxEthNgDtK69P48Xm39bXLHi8eqfeFwxTTYEJE/edit?usp=sharing

Hope you like it, lemme know if you have any questions.

0 Upvotes

92 comments sorted by

View all comments

54

u/HCMXero OC: 1 2d ago

This is definitely not beautiful.

-3

u/FluidModeNetwork 2d ago

Any suggestions?

22

u/notionalsoldier OC: 1 2d ago

There’s nothing beautiful about a simple spreadsheet with conditional formatting. This isn’t even a visualization, nor does it convey any particular story. It’s just… data

2

u/tyen0 OC: 2 2d ago

conditional formatting

That also gives a false correlation between the different category rankings that does not exist.