Hi,

In order to reduce the column size when the number of series is changed
you will need to play with the Gap Width property. To be found on the
Options tab of the Format dialog for a column series.

Any reason why you can not set the values of the unwanted columns to
zero, so they are not displayed?

Cheers
Andy

ramkumar_cpt wrote:
Hi,

I have one doubt in bar chart. I have created one bar chart.
That contains 4 serious collection. All 4 bar shows well. But if i
delete the one or two serious collection, Bar size is increased. Bar
shows bigger size. I need the same size even if i delete the serious
collection. Is it possible in excel chart?

I use maximum of 4 bars only. I want the same size, even i
increase or decrease the serious collection.

Pls help me.

Ram.



--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info