Use the REPT function to create histogram directly in a worksheet. This method is useful when you need a visual summary of many values and to perform what-if analysis with the existing numbers. Use the formulas in column D to graphically draw solid squares to represent the numbers in the table:
=REPT(CHAR(162),B2/100)
This formula will draw certain number of solid squares based on the number divided by 100. If the number is 945, the formula will draw 9 solid squares.  If the number changes, the result will change.  Of course copy this formula down.  See the diagram below.

Histograms

Advertisements