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 »3 comments to this article

  1. Is there another solution? I need to keep axis type as Date axis. Maybe I have to do something with my data source, but I don’t know what. Can anyone help me?

    Thanks in advance.

    Reply

  2. Simple solution: hide empty place in Excel graph. Thank you.

    Reply

  3. 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.

    Reply



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