I have four column chart and the gap between series is big. I used the gap width button and the column width is increased overlap adjustment does nothing. Is there a way to bring the columns closer to each other?
I was kind of hoping for a screen shot. You say the chart has 4 columns. Does that mean 4 categories, or 4 series, or something else? How large is the pivot table (how many rows, columns), and what fields does it have in what areas?