Edward,

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.

Zak



On May 8, 2017, at 4:55 PM, Edward Iglesias <[log in to unmask]<mailto:[log in to unmask]>> wrote:

Hello All,

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?

Thanks,

Edward Iglesias