R
Revels
Hi, first time poster here!
I'm not too experienced in Excel so I may be overlooking somethin
obvious, here's my problem.
I am making charts to record the daily attendance figures of the gym
work at, so we can track how many people are in the gym at any give
time, in quarter hour intervals.
On the worksheet, the x axis shows the time of day, starting at 09:0
and continuing in increments of :15 until closing time at 21:00 (eg
09:00, 09:15, 09:30, 09:45, 10:00 etc)
The y axis represents a user of the gym, starting at User 1, an
continuing downwards to User 60. There are really usually a maximum o
50 visitors a day, but I gave myself 10 extra just in case (this is
small college gym btw, in case you were wondering why the numbers ar
so low!)
Using the gym register, I am marking the period that the user is in th
gym with a 1, and leaving the rest of the cells blank. So if a user i
in from 10:15 to 12:30, the row of cells between them times have a 1 i
them.
I go through the register and continue filling in the rest of the cell
for each user.
Now looking at the worksheet I can look at the columns and can see ho
many people are in the gym at a given time, but to make it easier t
see, instead of a sheet full of number 1s (!) I use this data to mak
... a chart!
I've chosen a stacked area chart because of the way the data overlap
and layers itself, each layer (series) representing the user.
Creating this chart is tedious, because I am creating a series of 6
users. This means clicking on the New Series box, then selecting th
name of the series from the chart (user x) then selecting the range o
cells for that users data. Then repeating 60 times. Yawn.
THE POINT OF THIS POST!
The thought crossed my mind, there must be an easier way, instead o
creating a worksheet and chart for each day, I could make a blan
sheet, then make a chart for it using the method above, so when I star
filling in the sheet, the data starts accumulating in the chart.
I have, and it works beautifully, but here's my question (finally!)
Before I start filling in the data proper, I would like to copy thi
blank preformatted worksheet and chart, and paste them underneath eac
other as many times as there are days in the month.
The charts are inserted beside the worksheets. If you want to see fo
yourself what I'm doing, you can grab the file 'HERE
(http://www.ulala.karoo.net/GymAttendance.xls)
Thank you for your time :
I'm not too experienced in Excel so I may be overlooking somethin
obvious, here's my problem.
I am making charts to record the daily attendance figures of the gym
work at, so we can track how many people are in the gym at any give
time, in quarter hour intervals.
On the worksheet, the x axis shows the time of day, starting at 09:0
and continuing in increments of :15 until closing time at 21:00 (eg
09:00, 09:15, 09:30, 09:45, 10:00 etc)
The y axis represents a user of the gym, starting at User 1, an
continuing downwards to User 60. There are really usually a maximum o
50 visitors a day, but I gave myself 10 extra just in case (this is
small college gym btw, in case you were wondering why the numbers ar
so low!)
Using the gym register, I am marking the period that the user is in th
gym with a 1, and leaving the rest of the cells blank. So if a user i
in from 10:15 to 12:30, the row of cells between them times have a 1 i
them.
I go through the register and continue filling in the rest of the cell
for each user.
Now looking at the worksheet I can look at the columns and can see ho
many people are in the gym at a given time, but to make it easier t
see, instead of a sheet full of number 1s (!) I use this data to mak
... a chart!
I've chosen a stacked area chart because of the way the data overlap
and layers itself, each layer (series) representing the user.
Creating this chart is tedious, because I am creating a series of 6
users. This means clicking on the New Series box, then selecting th
name of the series from the chart (user x) then selecting the range o
cells for that users data. Then repeating 60 times. Yawn.
THE POINT OF THIS POST!
The thought crossed my mind, there must be an easier way, instead o
creating a worksheet and chart for each day, I could make a blan
sheet, then make a chart for it using the method above, so when I star
filling in the sheet, the data starts accumulating in the chart.
I have, and it works beautifully, but here's my question (finally!)
Before I start filling in the data proper, I would like to copy thi
blank preformatted worksheet and chart, and paste them underneath eac
other as many times as there are days in the month.
The charts are inserted beside the worksheets. If you want to see fo
yourself what I'm doing, you can grab the file 'HERE
(http://www.ulala.karoo.net/GymAttendance.xls)
Thank you for your time :