Excel chart series data point gap
Posted on 1998-11-03
how does one place a gap in the line of a line graph, at a point where no data is available?
example (my problem) is a sampling site, where samples are taken each year. data best viewed using line graph but in some years no sample was taken. how to show this data best is to keep the line going but have a small gap at the point in the line where the data would have been. like this... ---| |---- where the gap between the pipes is the year that wasn't sampled.