We use a bubble chart (https://developers.google.com/chart/interactive/docs/gallery/bubblechart#data-format) to show this kind of data where the X-axis values are 1-7 to show day of week, the Y-axis values are 0-23 to show hour of day, and the bubble-size/color is patrons per hour. In the Google version cited, the size and color can vary independently to show different values but we found them to work well together, e.g. a small yellow bubble shows low usage and a large red bubble shows high usage.
On May 8, 2017, at 4:55 PM, Edward Iglesias <[log in to unmask]<mailto:[log in to unmask]>> wrote:
Can anyone recommend a program to track usage. We have a makerspace and
students sign in to use VR or a 3D printer. Thus we end up with a
speadsheed that looks like
Date Name ID# Time VR 3D Print
5/8/17 Some Student 3:00 Y N
5/8/17 Another Student 3:25 N Y
What I am trying to do is figure out when our busiest times are and show
that in a chart of some kind. Using Excel this is possible but cumbersome.
Can you share some solutions?