I have a lot of charts that holds data from 3 years at the current moment in
time. At the moment the chart displays the data from Oct 08 to Dec 09 and I
want to change that to display Jan 09 to Dec 10 and I have been modifying the
source data to the formula below

='Resource Groups'!$A$2:$A$70,'Resource Groups'!$N$2:$AK$70

- however through a trial and error I find that when I extend the data on
the vertical axis in the legend it displays the words Series 1 through to
Series 70 and since I have approximately 100 charts to amend I do not have
the time to go through each one and add the legend individually.

The odd thing is that on some charts amending the source data works fine and
the legend displays what it is meant to.

Can anyone suggest why this is now happening. I am running Excel 2003.

thanks
Beverly