Forum Discussion
Rachael0711
Dec 01, 2021Copper Contributor
Line with markers graph
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
Sort By
- Riny_van_EekelenPlatinum Contributor
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 made on a Mac, but it's similar for the PC version of Excel)