View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.programming
Saxman Saxman is offline
external usenet poster
 
Posts: 111
Default Graph Source Data

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)

--