This content has been marked as final. Show 2 replies
I have a set of data like this (in orange)
The average per product is in blue and know I like to calculate the 'average per product' devided by the 'total avere' and put the numbers (those in green) in a bar chart.
Example Product A:
The average is 3.5 ((5+2) / 2 ) and compared to the total average i get 92 % (3.5 / 3.8 * 100)
Example Product C:
The average is 5 ((6+4) / 2 ) and compared to the total average i get 132 % (5 / 3.8 * 100)
How do I do that?