Hi everyone
I have times booked to attend a service, for example:
Booked1.jpg
I want to create a graph (preferably a pie graph) that shows me the times booked, but I’ll have hundreds of lines.
Therefore, I want to be able to group the same in/out times together.
For example:
Booked2.jpg
So what I want to see in the graph (using the example), would be a pie graph with only 6 colours. I want to see that 9:00am-2:30pm has the largest wedge of the pie, then 8:00-2:00pm, etc.
The information that I am trying to get from the graph, is which times are the most popular, next popular etc to least popular.
Any ideas and assistance would be very helpful.
Thank you
Bookmarks