Download parking_lot_diagram_example.xls. Creating these Parking Lot diagrams in Excel is actually quite easy. We can use Excel’s conditional formatting functionality to change the box colour based on status, and the trick to producing the progress bar is to strategically add a bar graph that has no formatting area or legend.