+ Reply to Thread
Results 1 to 2 of 2

How to plot 3 data sets on the same line graph, but not connect the data?

  1. #1
    Registered User
    Join Date
    12-16-2008
    Location
    Nowhere
    Posts
    1

    How to plot 3 data sets on the same line graph, but not connect the data?

    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.
    Last edited by marklight; 12-16-2008 at 02:42 AM.

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,436
    You need to plot 3 separate series.
    I can't tell from your posted data exactly how you have your data currently.

    Post a workbook of your data and the chart you have managed to create so far.
    Cheers
    Andy
    www.andypope.info

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1