Number crunching is the kind of art you don’t appreciate fully until you have to do it. As we were analyzing the data from the social media report, one of the biggest challenges we had was finding the right kind of chart to represent the trends we were seeing.
A big help would have been Chart Advisor, a little experiment from Microsoft Office Labs. This division plays around with prototypes and ideas that you can try before they’re fully released. Chart Advisor, according to the website, “ … was created as a concept test to explore new ways Excel users can create graphs quickly and effectively. Based on the data in your spreadsheet, it identifies, ranks, and displays an array of charts most relevant to you so you can make the most out of your presentation.”
Give it a shot and see if it helps you crunch your numbers.