additonal bars not showing up on charts

My guess is that something is wrong or unexpected with the values in column D or column E, but I cannot see what is wrong from the picture. My advice is to look very closely at what values are in column D and column E and see if it is exactly what you expect.

1a) Format dates in some form of mm/dd/yyyy to see the entire date being represented. From your description and picture, I cannot tell if these are month -- year dates or if they are month-day (year 2017 implied???) values. Format them as the full month, day, year so you can see what date is actually stored in the cells in column D.
1b) Alternatively, format these cells as general so that you can see the serial number stored in these cells. Remember that the actual value behind dates (assuming they are not dates stored as text strings, which you chart will interpret as the number 0) is a number that represents the number of days since Jan 1 1900 (the date 17 Oct 2017 is serial number 43025, for example). By removing the number format, you can see the underlying serial number and see if the numbers are something reasonable.
1c) If neither 1a or 1b result in a change in the display of the cells, then the values are likely "dates stored as text" and you need to convert them to real date/time serial numbers. You can test using the ISTEXT() function. A VALUE() function, or a Text to columns command, or some other strategy will be needed in this case to convert the date strings to real date/time serial numbers.
2) Make sure the number of days in column E is correctly calculated/entered. Make sure they are numbers and not numbers stored as text.

I cannot readily think of anything else to suggest without seeing the actual file.