How can I compare frequencies and intercept event dates in Excel?

Question

I need a way to look at one type of event as a basis, and then graph how several other events interact with the base event.

Example: data set of events has occurred for a group of locations (1000+ locations): event 1 occurs ~every 4 weeks over course of 6 months event 2 occurs ~2 weeks over course of 6 months event 3 occurs randomly, no regular frequency

I want to see a graph or chart that shows how often the 3 events occur for each location on the same day, within 1 week, within 10 days, etc.

Any ideas on how to use Excel to show this data?

thanks