Help Creating chart that counts the number of excel entries in a date range (decade)

Good evening,

I am looking for some advice how to create a chart that summarize some data.

In excel, I have recorded coins that I have found metal detecting (column A=date found; column B=type of coin; column C=Date of coin; Column D=location). Each row is a different coin.

The chart I am trying to create would count the number of coins found within a date range at a certain location.

For example:

Location	1940-1949	1950-1959	1960-1969	1970-1979
Park 1	0	0	15	30
School 1	0	0	20	14
School 2	0	2	10	20
Park 2	0	0	12	9

What is the best why to obtain this type of chart and have it easily updated as new entries are added?

Thanks,
Rob

Thanks oeldere for the quick reply.

That is a little different than the table I was looking for.

I am looking for a table similar to the one in the original message above. The table would use data from the excel spreadsheet I attached and categorize the location and the number of coins within a certain date range (e.g. 1980-1989). I have generated a pivot table that will count the number of coins at a particular location and by individual date, but it is a large table. I am wanting a quick table/summary table that shows the location, and the number of coins with dates within a decade. Please see table in 1st message above.

Thanks,
Rob

Hi Oeldere,

That looks exactly on the mark. Thank you so much for your help !

Rob