How to Exclude Dates With No Data From Charts in Excel

Techwalla may earn compensation through affiliate links in this story. Learn more about our affiliate and product review process here.

When you create an Excel chart that has your data organized by date, any gaps in the data will make your chart look incomplete or incorrect. When Excel creates a chart with dates in the data set, it automatically fills in any gaps in the dates and includes them in the X-axis. If you want to remove these extra dates, you just need to change the axis options.

Advertisement

Step 1

Open the Excel file that holds the chart from which you want to exclude dates.

Video of the Day

Step 2

Click the X-axis, located underneath the chart, so that it becomes surrounded by a small box. Right-click inside the box and choose "Format Axis" from the popup menu.

Step 3

Click "Axis Options" on the left side of the "Format Axis" window. Locate the three "Axis Type" options in the middle of the screen on the right side of the window. Click the radio button next to "Text axis."

Advertisement

Step 4

Click "Close" to close the "Format Axis" window. The chart will update and remove the extra dates that hold no data.

Video of the Day

Advertisement

Advertisement

references