Did you get the error when defining the name, or when trying to apply it to
the chart?

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Saxman" wrote in message
...
Tom Ogilvy wrote:

Why not used defined names

insert=Name=Define
Name: =MySeries1
Refers to: =Offset(Archive!$B$2,0,0,Count($B:$B),1)

then in the Chart, use

=Bookname!MySeries1


instead of
=Archive!$B$2:$B$150

Repeat for all series.

Good idea.

I tried '=MySeries1' and =Archive!$A$1 in 'name' and all I get is the
following
error message 'That name is not valid'.

Where am I going wrong? Probably because I got some reference wrong.

It sounds like I need to use a name of my own, but which?

I really am thick!

I posted the following in Refers to:

=Offset(Archive!$B$2,0,0,Count($B:$B),1)

--