John Nelson found a way to make geographic heat maps in Microsoft Excel using pivot tables and conditional formatting. via FlowingData.