Microsoft Excel overlapping Bar charts/Histograms

Follow Reference 1 to generate bar charts that look like:

Follow Reference 2 to generate bar charts that look like:

References:
1. http://peltiertech.com/WordPress/overlapped-bar-chart-longer-bars-in-back/
2. http://peltiertech.com/WordPress/overlapped-bar-chart-thinner-bars-in-front/