Forum Discussion
gonrodrigues
Helper III
10 years agoWaffle 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
Impactful Individual
10 years agoNot an easy question!
gonrodrigues
Helper III
10 years agoI really thought it was easy but for some reason i couldnt get the answer :smileysad: