If you've have lots of data and lots of analysis to do, but little time or skill, you need Excel's Power Pivot feature. Here's how to get started with it.

Appending records from different data sets into a single list or data range can be tedious if you’re doing it manually. Instead, use Microsoft Excel’s VSTACK() function.

Adding Data Sets One at a Time Launch Excel and load the spreadsheet containing the data you want to plot. Select the first set of X and Y axis data for your chart.