Eatson Creating Pivot Charts

 Creating Pivot Charts

First downloaded a CSV file of FIFA players, including their statistics, age, height, salary, etc

Imported CSV file onto Google Sheets (File -> Import -> Upload CSV) 

Then, I created a pivot chart (Insert -> Pivot Chart)

Selecting the relevant columns, rows, and integer values I was able to create a pivot chart that highlighted the players age by alphabetical order and compared their potential relative to their age and current rating.

Furthermore, I decided to create a pivot chart that sorted players by their overall ratings in order to compare their potential. I also used to filter tool to make sure that these comparisons were only between attacking players (ST, LW, RW, LF, RF, SS, LS, RS) and excluded midfielders (LM, RM, and CAM included), defenders, and goalkeepers altogether. This gives us a very clear cut visual representation of the highest rated attackers in the game.