Hi
Instead of workbook name, use sheet name, which contains your data - excel
replaces it with workbook name automatically. I.e. you enter the reference
as
=SheetName!RangeName
Arvi Laanemets
"bobburg" wrote in
message ...
I am using Office 2002.
I am trying to create a chart that has only one Series called Data. The
values for DATA is a name called SCROLL_DATA. The name has been defined
using the Insert-Name-Define action. The workbook is called Quality
Escapes.xls I have entered the following in the values box as I have
seen many instruction as follows
=Quality Escapes.xls!SCROLL_DATA
What am I doing wrong.
--
bobburg
------------------------------------------------------------------------
bobburg's Profile:
http://www.excelforum.com/member.php...o&userid=22006
View this thread: http://www.excelforum.com/showthread...hreadid=466641