I have about 100 graphs that need updating each month and I want to find a
way that I don't have to go into each of them to extend the range manually.

THe source data contains formulas out until Nov 2007, so the source data for
the graphs gets automatically updated when the new figures are entered
elsewhere in the spreadhseet.

I am wondering if a macro could be used?