Line Graph Suggestion

I see two major, distinct parts to this question:

1) Generating the summary data in the spreadsheet [first impression is some kind of COUNTIFS() or FREQUENCY() function, though I also suspect a pivot table could be used].
2) Generating the chart based on the summary data.

At this point I would ask which part are you needing help with? Generating the summary data or creating the chart from the summary data?

However, this doesn't break my x-axis into quarter increments. I believe it will just do it by years.

I don't see any reason why Excel would only be able to do years and not quarters or months or whatever part of a year you want to include. I would expect that you can choose whatever division of a year you want by programming your summary statistics to do the summary by quarter or whatever.

With the limited information you have given, I'm not sure I can recommend anything more than to look into the COUNTIFS() and FREQUENCY() functions (https://support.office.com/en-us/art...6-c6d90033e188 ) or pivot tables to summarize the data as needed. In order to provide more specific suggestions, we will need a better idea of the input data you have, how it is arranged in the spreadsheet, and so on. A sample spreadsheet with representative data uploaded to the forum (note that shortcut attachment tools don't work here, so use the "manage attachments" link in the "go advanced" main post editing window) would probably be best.