Combine values from multiple columns.

Combine values from multiple columns.

I am not sure about the best way to go about this so let me explain what it is that I am trying to do. I have essentially a golf score card with each hole as a column and each player score in the row's. I would like to create a pie chart that shows their percentage of 1' 2' 3' 4' and so on. I can easily do this for one hole by creating a pie chart. How could I do this for a whole game 18 holes not just the one? I was looking to do an aggregate formula and try to combine all columns but I am unable to add all the holes without any functions. I am sure that I am going about this in all the wrong ways.