Creating a text histogram,






The formulas in columns E and G graphically depict monthly budget variances by displaying a
series of characters in the Wingdings font. This example uses the character n, which displays as a
small square in the Wingdings font. A formula using the REPT function determines the number of
characters displayed. Key formulas include




E3: =IF(D3<0,REPT(“n”,-ROUND(D3*100,0)),””)
F3: =A3
G3: =IF(D3>0,REPT(“n”,ROUND(D3*100,0)),””)

Comments

Popular posts from this blog

Writing Systems Of The World

International Phonetic Alphabet

GRBL Feed Rate