Chart Advisor is an addon for Excel 2007 that provides an alternative approach for creating charts in Excel 2007. It is a prototype from office Labs and is available as a free download.
According to Office labs it uses an advanced rules engine to scan your data and, based on predefined rules, displays charts according to score. Based on the score it will preview charts you can pick up the best chart for your data and incorporate in your excel worksheet.
You can modify the chart once it is created using modify chart options on the left panel, once you are satisfied with the chart you can click insert chart to insert in your worksheet.
Overall this is quite useful for people like me for presenting the data in interesting ways. It works Excel 2007 installed on 32 bit windows xp or Vista. The analysis is limited to 8000 cells at the moment and it promptly crashed after few mins of usage, typical of beta software.
Download Chart Advisor