Excel 2007 : Batch changing data range for multiple charts?

Hi,

I have a worksheet which consists of multiple columns, for example:

18 to 21 yr old | 21 to 25 yr old | 25 to 30 yr old | Total

Under each of these columns I have inserted several rows which contain data from a survey.

On another sheet, I've created several charts using data from the 18 to 21 yr old column.

My question is - is there a fast way to change the data range of the charts from the 18 to 21 yr old column to the 21 to 25 yr old column without having to painstakingly adjust each chart manually?

I would like to end up with a series of sheets which contain identical charts for each age range.

I'm using Excel 2007.

Thanks :-)

For those who are interested: http://peltiertech.com/Excel/Charts/ChgSrsFmla.html