Compiling Data By Date

Some people maybe take time to combile all the data by date/week/month/year, actually PivotTable tool at Microsoft Excel is useful for combile the data in table by date/week/month/year and also plot in into chart.

Instruction:
1. Select the data, click Insert, PivotTable,select New Worksheet or Existing Worksheet,select location, OK.
2. The PivotTable Field List will then shown at the right, select the Date and Quantity field list, then the table will created.