Oct 06 2022 03:54 PM
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
Oct 06 2022 05:41 PM
Like this - the minutes waiting up to two hours on the vertical, the dates on the horizontal!
Oct 07 2022 01:57 AM
I don't see a connection between the data in your sheet and the drawing of the chart...
Oct 07 2022 01:20 PM
Oct 07 2022 01:32 PM
Oct 07 2022 01:37 PM
I created a Line and a Stacked Line based off the drawing provided.
Please see attached:
Oct 07 2022 01:38 PM
In the attached workbook, I have created 5 possible charts based on your sample data. Perhaps there is something you can use.
Oct 07 2022 01:59 PM
I could just use yours but I don't understand, When I select and choose line it uses the line numbers
Oct 07 2022 02:13 PM - edited Oct 07 2022 02:15 PM
@Lise Quinn as I noted above, did you select SCATTER plot option??
in older versions of excel I think it was called x-y plots
Oct 07 2022 02:18 PM
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.
Oct 07 2022 03:22 PM
@Hans Vogelaar 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
Oct 07 2022 04:27 PM
There's a few ways to update a chart's data source. You can select the chart and then click-and-drag the blue box around the data to expand the range:
Oct 07 2022 04:50 PM
Oct 08 2022 02:21 AM
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:
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.
Oct 12 2022 09:49 AM
@Hans Vogelaar I ultimately converted to minutes to a number rather than a time type of item. Once I did that I was able to make a line chart, thank you for all your input and helping me think this through. I got it done in time for my presentation and my CIO was very happy