I have some Excel data that only shows data for week days as I do not work weekends. However, when I came to chart it, it put the weekend dates in, showing blanks. This wasn’t what I wanted.
Right-click on the horizontal axis showing the dates and select Format Axis. Under the Axis Options, for Axis Type, select Text axis. The Chart then just displays the data for the weekdays.