Controlling the Display of Time-Based Axes
By default, when you create a chart that has a dimension on an axis, missing values are not displayed on that axis. For example, if you create a bar chart showing revenue by product category, but there are no revenue values, including zero, for televisions, then televisions will not appear on the horizontal axis in the bar chart.