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 st...
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.
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.
I suspect you inserted a "2-d line" chart and you need to use the "scatter plot" option. highlight the data in columns A and B and select scatter plot and it should work.