Any Office Mac Excel gurus?

Discussion in 'Mac Apps and Mac App Store' started by atomheartmother, Aug 22, 2009.

  1. atomheartmother macrumors regular

    Joined:
    Aug 27, 2006
    #1
    I'm working a big project with line graphs and whatnot, and I'm having a difficult time getting the line graphs to do what I want. Is anyone well-versed with entering data into the spreadsheet thing and then making line graphs?

    If this makes any sense, I want there to be a break in the line graph between baseline and intervention data points (i.e., there should be no line connecting data points 5 and 6). Is there anyway to do this (especially without completely rearranging things in my data set)? The data of interest is in column E on the data sheet.



    [​IMG]


    [​IMG]
     
  2. Crosbo macrumors newbie

    Joined:
    Aug 22, 2009
    #2
    You can graph the data as two separate sets of data...1-5, then 6 thru whatever. Put both sets of data on the same graph, then if needed you can format the lines for both lines to match.

    Hope that helps you to accomplish your goal.
     

Share This Page