The new Microsoft Office Labs group recently released a rather interesting tool for excel.
"Chart Advisor is a prototype that provides an alternate approach for creating charts in Excel 2007. This add-in uses an advanced rules engine to scan your data and, based on predefined rules, displays charts according to score. Top scoring charts are available for you to preview, tweak, and insert into your Excel worksheet."