Wednesday, December 14, 2011
A Micro-Graph for All Versions
This is so cool. Here is a way to make a simple Micro-Graph that resides in your table and Works in Any Version of Excel!
This is really easy. Let’s say you have your Products (or sales reps) in Column A as illustrated above, and in Column B you have the Units Sold. Here is the formula you should put in Cell C2:
= REPT( “l” , B2/10) and then copy it to C7
For Each Approximate Count of Ten, the formula puts a Hash Mark, (using an Arial font works well), in Column C. The result is a simple, easily read, Micro-Chart!
Try it out in the office, and wait for the Kudos to Roll In!