Using Defined Names in a Chart

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

[Arvi Laanemets]

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" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>

[Tushar Mehta]

In article <[email protected]>,
[email protected] says...
>
> 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

='Quality Escapes.xls'!SCROLL_DATA

Note the presence of the single quotes.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions