I'm having trouble tracking the frequency that a category of events occur over the course of given dates. So if my categories are "X", "Y", and "Z", I want to track how often they happen over a given date range and also be able to track the frequency that they happen on certain days of the week/months of the year etc.
So far I have my data in two columns, a "Date" column and a "Category" column. I have a "Day of the Week" Frequency bar chart that I am taking data from another table using the formula "=SUMPRODUCT(--(WEEKDAY(A2:A250)=1),--(A2:A250<>""))"
Here is a screenshot of my setup currently.
In a perfect world, I would like to have a multiple line graph with each category as the lines and the time range on the x axis and the frequency on the y axis.
wmnDZ3Z.png
Bookmarks