Excel 2000 Chart Setup Help

I have bar graphs that copied over from another file. The 3rd and 4th chart listed are how I want it to look. The bars are stretched only to the half way point of the chart window. The right half contains the legend.

When ever I update the source data and change it to make my new file data the bars stretch all the way across the whole chart window. The first and second chart show this.

So every time I update a new chart with new information the charts change from small to big. How do I make all the charts look like chart number 3 and 4 after I update the data?

Any Ideas?

Thanks

PS I am using Excell 2000

Also, Everytime I change the last series it strechts. So after I update the last series or hit okay then it changes.

Thank you for your response. I understand that its eaiser to do it this way. These charts were created by antother person and I am suppose to keep them the same.

Do you know how to modify them like I was asking? I mean it has to be possible becuase it was done the first time they were created. I just cant find it for the life of me, I have been through every option I can find.

Thanks

Try extending your source data down to include a few blank rows

HTH
Rich