The Pivot Table is a tool that Excel uses to create custom reports from your spreadsheet databases. All you need is one common, unique field. Here's how to set it up with multiple spreadsheets.

How to create the PivotChart in Excel At this point, you have a PivotTable that counts the number of invoices per month and by the year. From here, creating the year-over-year PivotChart is easy: ...