I came across this nifty tool, the Juice Analytics Chart Chooser, for picking out the right chart/graphic type for the type of relationship you’re trying to show. You check off what characteristics you want to highlight in your data (comparison, distribution, composition, trend, relationship, and/or table) and it filters in the possibilities that fit your needs. The nice thing about this website is that you can download templates for Excel or Powerpoint to get you started. One of the most time consuming and frustrating tasks I run into is when a researcher gives me a spreadsheet full of data and an idea of what he or she wants their data to show but the dataset has been laid out in a way that I would have to recreate the dataset to get Excel to produce the appropriate chart. These templates hopefully will give you a good idea of how to lay out your data table to make charting a breeze.