ByteTheBullet

Charting Data That Has Gaps

Discussion created by ByteTheBullet on Mar 26, 2012
Latest reply on Mar 26, 2012 by Stephen Huston

I have a data set that has some values associated with dates. Not every date has a value, however, and I'd like to create a chart that includes those "missing" or "null" values. I suppose another way to describe what I'd like is to have a gapless x-axis, even though some values of X will not have a value for Y. I do not need to "connect" values on either side of a gap, as the fact that there is no value for some dates is important in and of itself.

 

I'm hoping that there's some method to present a chart such as this without having to specifically create a "zero" record for every date that has no value. Thanks!

Outcomes