how to do piled up bar chart

I assume these are referring to the histogram2.xlsx file

How do I get rid of Yellow Dates in the PIVOT table ?

I don't know exactly how your version's UI will show this. In my version, I selected the "Row Labels" drop down -> Date Filters -> Between -> selected dates of 29 August and 7 Sep.

How do I reorder of PILE UP ? I like complete to come first in the BAR.

I selected the cell with "complete" in it -> Grabbed the cell border (that was probably the hardest part) -> Drag "complete" to where I want it to appear in the pivot table (to the left of "cancelled"). The "stacks" in the stacked column will be in order from left (bottom) to right (top).