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

The EVK‑M8xCAM

Writing Systems Of The World

വിവാഹ ബന്ധത്തിലെ ബലാത്സംഗം രാജ്യത്ത് കുറ്റകരമാക്കാന്‍ ആകില്ലെന്ന് കേന്ദ്രസര്‍ക്കാര്‍