How to chart multiple drug levels over period of time?

I don't see an attempt to create the chart or any other indication of what you are having trouble with. I am not exactly sure what you want, but, to go for the easy first guess:
1) Clear A1 (makes it easier for Excel to guess at what you want for X and Y value ranges in the chart.
2) Select A1:MR62 and Insert -> Chart -> XY scatter
3) Make sure Excel chooses the correct ranges for the data series (use "Switch row/column" and/or the Select Data dialog to fix, if Excel guesses wrong).
4) Other formatting as desired.

The resulting chart should have all of the data series in a single chart. There is a lot of data that will likely be bunched up on the chart, making it difficult to read. Is that what you want, or did you have something else in mind?

Hi Thanks.
I think clearing A1 has helped, but as you said got a not very useful graph- as shown in the spreadsheet (see update attachments)
I put an example of single graph which represents what I want, drug levels Y axis, time X axis but for one patient only, I want the final graph to include all of my samples, the 61 one patients, is it remotely possible?

It's not yet clear to me exactly what you want to do.

In this latest file I:

1) Entered "patient id" in cell A1 of sheet MPA T.
2) Told Excel to make the table of data in MPA T a filtered list (https://www.wikihow.com/Use-AutoFilter-in-MS-Excel ).
3) In the "patient id" dropdown of column A, I unchecked all and selected a random patient id. The filter hides every record except for the selected patient.
4) Select the Graph tab to see the result on the chart. All of the data series except for the selected patient id are now hidden, and the chart only displays the data for the selected patient id.
5) From here, I can go into the data table and select any given patient id to see that patient's chart.

Is that what you are trying to do?

I did not attach anything to my previous post (#5), so there is not attachment to be found.

It is still not clear to me exactly what you want. Reading between the lines, I see you kind of describing a "panel chart". Something like this? https://peltiertech.com/Excel/Charts...venScales.html
Or maybe something like this example from Andy Pope (http://andypope.info/charts/miniplot_xy.htm ) where he shows multiple "mini" scatter charts on a single scatter chart (most of the work is building the matrix of data that the actual chart will use).

Assuming I understand, the easiest (even if it is tedious) might be to build 61 separate charts. These examples should show that it is possible to put 61 charts onto a single chart, but there is a significant amount of effort transforming the raw data into something that will correctly display on a single chart, then some additional work to "fake" the individual axes and such.

Sorry for the late reply. I am not sure I understand your concern. I see no reason why you should not be able to create a graph that shows both data series.

Are you certain that the problem is that Excel is preventing you from showing two data series on one chart? It appears to me that Excel should easily allow two or more series to chart on one chart while correctly plotting each series against the correct x axis value (day). The only thing that seems "off" to me is that your charts have the "hidden and empty cell" setting set to "gaps". This setting means that, when Excel encounters an empty cell in the data series, it does not connect those points with a line. Is that the real problem you are having?

If that is the problem, the solution should be to select your chart and find the "hidden and empty cell" settings dialog and instruct Excel to "connect the points with a line". https://support.office.com/en-us/art...b-9ca49cb92274

Does that help?