Missing date in the chart

The table in this example shows dates and values. There is a missing dates. It causes a big blank space in the chart.

Table with missing dates

Chart with blank space

Excel provides options to display dates on the axis that can fix this blank space. Do right-click on the Y-axis and select Format Axis.

Format menu

In the Format Axis menu find Axis Type and switch it to the Text axis value.

Format Axis

Dates in the chart have no blank space, now.

Graph with no blank space

Add a comment »One comment to this article

  1. I was always wondering how to hide blank dates in chart. We have similar Excel file and this is very helpful and it solves our issues.

    Thank you.


Copyright © All Rights Reserved · Green Hope Theme by Sivan & schiy · Proudly powered by WordPress