How many times have you seen people choose the wrong type of chart to present their data? The folks at Juice Analytics have developed a "chart chooser" and it is available here. Juice Analytics is a consulting firm that provides heavy duty data analysis and their blog is an excellent source of useful tips on Excel and data presentation.
Chart Chooser begins by asking you to pick the purpose of your data and offers six alternatives:
Based on your choice, the app selects the appropriate charts from a universe of seventeen chart types. You then pick the chart form you want to use and can download a template (Excel or Powerpoint) to create that chart using your own data. The templates are particularly useful if you do not know how to create bubble charts in Excel or scatterplot charts in Powerpoint.
Now that Juice Analytics has taken the guess work out of chart selection, maybe those Powerpoints will not be so confusing.
I found Chart Chooser on the Extreme Presentation blog, an excellent source of advice on presentations.