Hui via Chandoo.org has written a fun article on the creative use of Number formatting to create unique charts.
Using Custom Number Formats to Highlight Chart Axis | Chandoo.org - Learn Microsoft Excel Online
He's also previously written about Data Tables (no, not the new Tables feature in Excel 2010)
Data Tables & Monte Carlo Simulations in Excel – A Comprehensive Guide | Chandoo.org - Learn Microsoft Excel Online
Thanks Hui and Chandoo for freely sharing....