Forum Discussion
Lise Quinn
Oct 06, 2022Copper Contributor
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...
Lise Quinn
Oct 07, 2022Copper Contributor
Like this - the minutes waiting up to two hours on the vertical, the dates on the horizontal!
HansVogelaar
Oct 07, 2022MVP
I don't see a connection between the data in your sheet and the drawing of the chart...
- Lise QuinnOct 07, 2022Copper ContributorOn 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.- HansVogelaarOct 07, 2022MVP
In the attached workbook, I have created 5 possible charts based on your sample data. Perhaps there is something you can use.
- Lise QuinnOct 07, 2022Copper Contributor
HansVogelaar I added the rest of the info to that charts xls you sent, and it won't let me expand the data to include the new data, it says
All I am doing is changing the range in the right hand pane from A4 to A5
I've attached the xlsx file
- Patrick2788Oct 07, 2022Silver Contributor
- Lise QuinnOct 07, 2022Copper Contributor
I could just use yours but I don't understand, When I select and choose line it uses the line numbers
- mtarlerOct 07, 2022Silver ContributorI 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.