 |
 |
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