Using Defined Names in Charts

B

bobburg

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.
 
D

Don Guillett

notice the ' placement or use no space in the name

=Quality Escapes.xls!SCROLL_DATA
='Quality Escapes.xls'!SCROLL_DATA
 
Top