If you hold the Shift key when selecting the chart you can treat it like
a shape object and on the Format dialog is the parameters to change the
charts height and width.

ramkumar_cpt wrote:
Hi Andy,

Thank you for your answer. But your idea has one
disvantage. Some time the chart shows more gap if i encrease the gap
width. i have another idea for allign the chart. yes. If i reduce the
height of the chart the bar shows lesser size. If i increase the
height, then bar shows bigger size. I did this one by mannually use
draging. But i have one doubt. What am asking is Can we set the values
for hight.? (Not use dragingl). I have to enter the hight size? is that
option available in the excel chart?

Thanks..

Ram..



--

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