Chart Advisor is a prototype Excel2007 Add-In from the Office Labs that appears as a button on the Insert ribbon next to the standard charting tools.  It attempts to automate the process of chart generation by using an advanced rules engine to scan your data for properties that inherently make good charts.  It will generate some charts, rank them, and display the set as thumbnails in a new dialog.  From this dialog you can manipulate the charts by changing how the data is mapped and filter out data from the chart.

More info: Download | Video | Home Page