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