Hello everyone,
I really enjoyed the post on using Wingdings to replace radar charts. But now I have a few questions on editing.
http://chandoo.org/wp/2008/10/07/excel-radar-charts-replacement-spot-matrix-download-template/
If we were to just choose between 3 circles rather than 5, why wouldn't
=MID(A$8;FLOOR((N2-1)/3;1)+1;1) work? (The wingding text will be in Cell A8)
Also, in this example - there is a maximum limit of 25.
I don't think I completely understand how the formula works. Could someone explain it to me so maybe I can set different minimum/maximum limits?
Thanks!!
I really enjoyed the post on using Wingdings to replace radar charts. But now I have a few questions on editing.
http://chandoo.org/wp/2008/10/07/excel-radar-charts-replacement-spot-matrix-download-template/
If we were to just choose between 3 circles rather than 5, why wouldn't
=MID(A$8;FLOOR((N2-1)/3;1)+1;1) work? (The wingding text will be in Cell A8)
Also, in this example - there is a maximum limit of 25.
I don't think I completely understand how the formula works. Could someone explain it to me so maybe I can set different minimum/maximum limits?
Thanks!!