Excel chart series gap

[afdmello]

Hi Folks,

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?

Thanking you,
AFD

 

[Jon Peltier]

What's the data look like? What's your chart look like?

 

[afdmello]

I have made the chart from a pivot charts. and it has 4 columns. I am doing this on a single page with many charts for a report and thought of making it smaller.

Thank you for your time for asking.

AFD

 

[Jon Peltier]

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?