Auto-increment data source cell references when copying charts

I need to copy a chart to several different pages of an Excel presentation spreadsheet, and would like for the data source cell references to increment by 50 each time. I'm copying the chart 50 rows down each time, but the data source references do not increment. When I change the data source references from "$A$25" to "A25", they get changed back to the "$A$25" absolute reference when I click Ok.

I expect that the chart objects aren't tied to specific cells on the presentation spreadsheet -- so Excel doesn't increment the references when they get copied.

But ........... is there any easy to increment the data source cell references when I copy so I don't have to manually change them on each new copy of the chart?

Thanks in advance -- Dave Received on Sat Jul 01 2006 - 08:06:01 PDT