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)),””)