Forum Discussion
How to chart wait times over days
I don't see a connection between the data in your sheet and the drawing of the 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.
- 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- HansVogelaarOct 08, 2022MVP
Don't worry about the message "The data range is too complex". Close that dialog.
To expand the range, click o a single series in the chart.
You will see something like this (it depends on the selected series, of course):
You see the "formula" for the series in the formula bar.
=SERIES(Sheet1!$B$1,Sheet1!$A$2:$A$4,Sheet1!$B$2:$B$4,1)
It has four arguments:
- The name of the series.
- The x-values, currently A2:A4.
- The y-values, currently B2:B4.
- The order of the series (is it the 1st, 2nd. etc.)
You can expand the series by editing this formula. You want to extend the range to row 13, for example. So change it to
=SERIES(Sheet1!$B$1,Sheet1!$A$2:$A$13,Sheet1!$B$2:$B$13,1)
You will see the effect in the data source:
and in the chart:
Repeat for each of the other series.
It is also possible to create a dynamic chart, for example by changing the data source to a table.
- 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
- HansVogelaarOct 07, 2022MVP
Excel is stupid. It uses the Date column as a data series. You have to click on the Chart, then click Select Data. Specify the date values as the X-values and remove the Date series from the chart.
- 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.