These obscure charts might be the key to visualizing your data.
The Gap Width option in Excel for Mac 2011 controls the spacing of bars in a column graph. Decreasing this percentage shrinks the empty space between columns by widening the columns themselves.