Grouping multiple values into a category
I think this should be relatively easy but I cant seem to work out how its done.
I am trying to group a number of 'values' so that I can see them on a pie chart.
eg. Imagine the following table
column header 1 column header 2 column header 3
5 6 7
6 4 13
3 7 4
I want a pie chart that shows column header 1 - 25%, column header 2 - 31% and column header 3 - 44% but because a pie won't allow multiple values I am struggling to make this happen.
Any help is appreciated