Chart Advisor from office labs

Chart Advisor is a plug-in to Excel which looks in to your data and displays appropriate charts for the data.

From Chart Advisor home page "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"

Download it from officelabs