Line with markers graph

%3CLINGO-SUB%20id%3D%22lingo-sub-3021226%22%20slang%3D%22en-US%22%3ELine%20with%20markers%20graph%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3021226%22%20slang%3D%22en-US%22%3EI%20am%20graphing%20behavioral%20data%20for%20a%20class%20project.%20We%20have%20our%20baseline%20data%2C%20then%20a%20break%20in%20time%20(about%20a%20month%20or%20so)%20then%20the%20collected%20data.%20I%20need%20this%20chart%20to%20appear%20with%20a%20gap%20in%20this%20time%20sequence%20but%20instead%2C%20it%20is%20connecting%20all%20of%20the%20data.%20The%20weird%20thing%20is%20in%20the%20empty%20cell%20options%2C%20gap%20is%20already%20selected%20but%20the%20line%20is%20still%20there.%20Need%20help%20ASAP!!%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3021226%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECharting%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3021282%22%20slang%3D%22en-US%22%3ERe%3A%20Line%20with%20markers%20graph%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3021282%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1234416%22%20target%3D%22_blank%22%3E%40Rachael0711%3C%2FA%3E%26nbsp%3BInsert%20two%20dates%20with%20no%20values%20to%20create%20a%20%22gap%22%20in%20the%20data%2C%20and%20make%20sure%20to%20set%20%22Hidden%20and%20empty%20cells%22%20to%20show%20as%20gaps.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Screenshot%202021-12-01%20at%2006.22.46.png%22%20style%3D%22width%3A%20629px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F330818i14EFC0C9F575D9D7%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Screenshot%202021-12-01%20at%2006.22.46.png%22%20alt%3D%22Screenshot%202021-12-01%20at%2006.22.46.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CEM%3E(screenshot%20made%20on%20a%20Mac%2C%20but%20it's%20similar%20for%20the%20PC%20version%20of%20Excel)%3C%2FEM%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor
I am graphing behavioral data for a class project. We have our baseline data, then a break in time (about a month or so) then the collected data. I need this chart to appear with a gap in this time sequence but instead, it is connecting all of the data. The weird thing is in the empty cell options, gap is already selected but the line is still there. Need help ASAP!!
1 Reply

@Rachael0711 Insert two dates with no values to create a "gap" in the data, and make sure to set "Hidden and empty cells" to show as gaps.

Screenshot 2021-12-01 at 06.22.46.png

(screenshot made on a Mac, but it's similar for the PC version of Excel)