how to do piled up bar chart

Please have a look at the image and This is what I have in mind to show in my bar chart.

date axis is horizontal and the Count of (Fix) is vertical

i filtered the date in the sheet then did the pivot table but still the pivot table included all the other dates that i did not want . What I wanted was Date only from 29th of Aug to Sep 6nd

Thanks for reading and any proposed solution.histogram2.xlsxhistogram.xlsxhistogram2.xlsxhistogram2.gif