Sorry the title is very bad - i want to plot 3 data sets on the same line graph- i want to connect the data points of the values within each data set, but i don't want to attach a line between each data set.
So i'm using the following data:
Time ---- 0 Hour Cultue--------2 Hour Culture--------18 Hour Culture
0 --------- 0.094 --------------------- 0.179 ----------------------1.11
20 ---------- 0.088--------------------- 0.28----------------------- 1.19
40 ---------- 0.075---------------------- 0.498------------------------ 1.29
60 ---------- 0.083 --------------------- 0.802 --------------------- 1.305
80 ---------- 0.106----------------------- 0.935 --------------------- 1.36
100 ----------- 0.117 --------------------- 1.033 ------------------------ 1.41
essentially i want to make an xy scatter line graph, and have all this information plotted together for form a standard bacterial growth curve. If you can get the idea from the data, the first data set was taken right away (0 hours) and it lasts for approx 2 hours. Then the 2nd data set starts and lasts again for another 2 hours approx. The last data set is after a huge gap in time (18 hours).
So I modified the data because i want the x axis to be time (in hours):
Time ------------Absorbance
0---------------- 0.094
0.3333-----------0.088
0.66666---------0.075
1----------------0.083
1.3333----------- 0.106
1.66666----------- 0.117
--------------------------- ( next data set - break in line graph)
2----------------- 0.179
2.3333------------ 0.28
2.33333------------0.498
3-------------------0.802
3.333333----------- 0.935
3.666666------------1.033
----------------------------- (next data set - break in line graph)
18---------------------- 1.11
18.33333---------------1.19
18.666666--------------1.29
19--------------------1.305
19.333333-------------- 1.36
19.666666---------------1.41
My problem is that when i graph this- using an xy scatter plot, i get all the points connected by lines. i would like however for there to be no lines connecting the data points ( x y value 1.666,.117 to 2,.179) or (xy value 3.666,1.03 to 18, 1.11). this way you can clearly see that 3 different experiments were conducted.
I'm pretty inexperienced with excel. sorry if this isn't explained very well.
Bookmarks