Hi,

I have set up defined names for a range of data, for example "dates" :-

=OFFSET(Data!$A$1,COUNTA(Data!$A:$A)-22,0,22)

and I have set the series of the x-axis of my chart to:-

="filename"!dates

However, when I go back to the file the series name has been changed to the
following:-

=[0]!dates

so that the chart no longer looks at the latest range anymore. I change the
name of the sheets/tabs after the names were defined and the chart was
created, would this create the problem?

Has anyone come accross this problem, any help is appreciated.

Many thanks,

Nils