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!

No comments: