Charting to show time

[graemekoz]

Good afternoon!

I work at a sporting venue and I need to graph patrons entering the venue in 10 minute intervals.

I want to use the 'kickoff' time as my zero point and then have a line graph showing the progressive entry of patrons before the kickoff and then after the kickoff.

I've just used numbers (0.00, -10.00, -20.00 etc) to show kickoff, 10 minutes before kickoff, 20 minutes before kickoff etc etc) but it isn't graphing correctly.

Does anyone know how to graph this kind of thing in excel?

I appreciate any advice!

thanks

Graeme

 

[Zack Barresse]

Please continue here:
http://www.mrexcel.com/board2/viewtopic.php?t=129516

.