I have a vertical bar graph, that has three columns of data graphed per location - and there are 5 locations.
So, in all, here are 15 vertical bars on the graph. Adding data labels is easy feasible - but how can I also add percentage labels?
Score - Monday Score - Tuesday Score - Wednesday
Loc A 31 54 31
Loc B 56 87 85
Loc C 32 45 98
Loc D 22 17 67
Loc E 56 87 49
I would also like to add a percentage column and label for each - Score - Monday; Score - Tuesday, and Score - Wednesday
Please offer suggestions on how to chart percentages for each of the columns above. I can add a percentage column in after each Score column that will be the percentage for the previous column.