To create partially overlapped column / bar charts in Excel 2007

Use overlap and gap settings in the format data series area.

A overlap of 100 will completely overlap one series on another

 

0 separates them completely