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



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