stacked line graphs?

[Steven Cappiello]

Hi,

 

I have a data set that looks something like the following in a subsummary layout.

In each subsummary I can generate a line graph of time vs. value for each patient I am sorted by.

 

What I would like though, is a stacked line graph, taking each of the lines from each of the sub summary sections, and stacking them on top of each other in one graph, with each line representing a patient.  Is this possible??    I'm not sure how to proceed.  Could someone please point me in the right direction?

 

thanks much in advance. 

 

 

patient 1

   sample 1   time = 1 second     value = 10

   sample 2   time = 2.1 seconds    value = 21

   sample 3   time = 3 seconds    value = 31

   sample 4   time = 4 seconds    value = 43 

 

 

patient 2

   sample 1   time = 1 second     value = 10

   sample 2   time = 2.1 seconds    value = 20

   sample 3   time = 3 seconds    value = 35

 

 

patient 2

   sample 1   time = 1 second     value = 10

   sample 2   time = 2 seconds    value = 20

   sample 3   time = 3 seconds    value = 35

   sample 4   time = 4 seconds    value = 44

 

 

Steven James

 

[Matthew F]

Since you have irregular time points, I think you want to choose a "scatter" style plot, not a "line" graph.  I'm not sure how to connect the dots however.  See attached. 

 

graph.fmp12.zip

[Steven Cappiello]

Thanks so much for taking the time to put together that demo file.  Unfortunately, connecting the lines is kind of important in this case.  I'd also like the graph to be dynamic in terms of new lines are added if there are more patient records, without having to manually add them to the graph.   Anyone know of a way?