Excel 2000 and Charts

I have a spread sheet with percentages and the perecentages have charts to represent the numbers. I update the spread sheet monthly. Is there away to update the charts automatically when I put in percentages into the spread sheet in Excel?