Any Office Mac Excel gurus?

[atomheartmother]

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.

 

[Crosbo]

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.