How to chart wait times over days

Lise Quinn 

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.