Forum Discussion
How to chart wait times over days
I want to make a chart out of this type of data to show the us and downs of wait times for our center, I cannot figure it out, I've been advised to use plot charts, but the don't plot, it's just a straight line, I cannot get date on the correct axis and the wait time won't go over 2 hours.. I am frustrated!
Lise Quinn
14 Replies
Like this - the minutes waiting up to two hours on the vertical, the dates on the horizontal!
I don't see a connection between the data in your sheet and the drawing of the chart...
- On the vertical axis or date column in excel, you will see dates of 7/1, 7/8, 7/15 in the next column you will see wait times for "in processing" service which lists 25:20 minutes and seconds, for 7/1. 1:07:21 one hour, seven minutes and 21 seconds for 7/8 and then on 7/15 the wait time for the same service, in-processing was 28:26 minutes and seconds.
I then have the wait times for the next service, "Out-processing" and so on.
The last two columns, total served and total turned away won't be included in this chart.
