Stretching the bar chart width in Excel

[abc.hegde]

Hi,

I am generating a bar chart and exporting in an Excel. When the number of bars are more, the width of the bar gets decreases and the width of the chart remains same. Since I am exporting in excel i would love to have the chart width getting expanded horizontally with keeping the bar width fixed. Can some one has any heads up for this?

[abc.hegde]

I myself was able to find a workaround. I wrote a customizer where I get the jfree chart and JasperChart objects. I read the dataset there and found out the numbe rof bars. I then updated the width of the chart using JasperChart object and the value set for width was calculated based on the number of bars to display.