As most Excel Gurus know, there is a new Micro-Graph functionality in Excel 2010. Cool stuff, but if you don’t have that permutation of Excel, here is a way to make a simple Micro-Graph that resides in your table and Works in Any Version of Excel!
This is actually very 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 show them once again why you are the Excel Guru of the Known Universe!
No comments:
Post a Comment