Forum Discussion
gonrodrigues
10 years agoHelper III
Waffle chart
An easy question: in waffle chart, my group is 'gender' and what should i have in excel to value? Thanks!
- 10 years ago
Hello,
Waffle Chart author here.
The Waffle Chart works nice if all the input values are between 0 and 100, but if one of them is over 100, then, the maximum value in the input is considered the 100% value and the rest of the values are calculated using cross multiplication.
There is a nice way to fix this, and it is using the Maximum value column. For example, if the values are greater than 100, then, you can provide what value is 100% in the Maximum value like this:
Group, Value, Maximum Value Female, 3400, 6000 Male, 2600, 6000
Then Female will become 57% and Male will become 43%.
Let me know if this does not solve the problem.
austinsense
10 years agoImpactful Individual
Not an easy question!
- gonrodrigues10 years agoHelper III
I really thought it was easy but for some reason i couldnt get the answer :smileysad: