Create a Combination Chart

Ever see those charts where there is a column chart and a line chart in one?  Also there are two y axis that show ranges on values on both the left and right side of the chart?  Well this is called a combination chart and it's commonly used to show two series of data together.  I see this most in stock price type of charts where the column charts shows the volume of stock trading activity and the line chart shows the stock price.  It's actually fairly easy to create this type of chart and it's a great way to show multiple views of data in one chart.  See the video to learn how it's done.

Use the INDEX & MATCH Functions to Perform Lookups

Have you every used VLOOKUP to do look ups from table to table? If you have you'd know there were some limitation on how it performs look ups, such as it would only lookup up the item in the first column of the table you are trying to bring data over from. There are ways to get around that limitation, but another method is to use the INDEX & MATCH functions to perform table look ups. It might be scary at first, but once you get the hang of using these two function together, you'll find it very useful. Check out the video to see how.

Create an X Y Scatter Chart

If you've seen charts that are trying to compare two things, it might have been as a scatter chart or X Y scatter chart. It's often a basic statistical chart that can give you an idea about correlation like answering the question of "as the weather temperature goes up, do more people by ice cream?" This type of visual analysis is done nicely with a scatter chart, so if this is what you're looking for check out the video to see how to create a basic X Y Scatter chart in Excel.