I am trying to make a time series graph of time vs number of "Y" & "N" in each timing(From 9AM to 9PM), but my hours are individually created. So how do i plot a time series graph? I tried grouping the hours together but i did not work out.
This is the excel data for the hours. I am trying to do it for Days as well but if i am able to solve the hours i might be able to do it for days too.
Pivot your hour columns.