Axis change means data no longer fill chart

[Rick_Borch]

I have a chart with weekday dates on the horizontal axis and data for both a primary and a secondary axis.  Because the weekend dates show up as spaces in the chart, I changed the Axis Type to "Text Axis".  The data now displays without spaces, but the data set is now displayed on only the left 2/3 of the chart space.  I assume that the shrinkage occurs because the empty spaces have been removed.  Any suggestions for how I can make the data fill the chart space?

[#2]

@Rick_Borch 

Could you attach a sample workbook (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar? Thanks in advance.