Create a PivotTable to show the aggregate sales by month and year.

Insert the PivotTable on the MonthAndYear worksheet.

Place Date as the row labels.

Show only months $($Date$)$ as the row labels

Place Year as the column labels.

Use an appropriate presentation of the Dollars field as the PivotTable values to display the total sales by month and year.

Create a PivotChart to show the data.