Previous Topic Next Topic

Using Named Ranges to create dymaic graphs

Closed
hero85 Posts 7 Registration date Thursday March 12, 2009 Status Member Last seen May 14, 2009 - Mar 18, 2009 at 02:32 PM
hero85 Posts 7 Registration date Thursday March 12, 2009 Status Member Last seen May 14, 2009 - Mar 19, 2009 at 04:05 PM
Hello,

I successfully created a graph using named ranges. Now in my graph, source data, in the 'value' box, this is the code I have: "Sheet1!myrange" .

After I saved this file, this code changed to "Book1!myrange" . I want to know if there is a way to keep 'Sheet1' there.

thanks.
Related:

3 responses

Answer 1 / 3
keeprise Posts 11 Registration date Saturday November 15, 2008 Status Member Last seen May 25, 2009 1
Mar 19, 2009 at 05:23 AM
hi,
i think you are getting this because you have only one sheet in the workbook.
try to fill some data in sheet 2 and see the result.
-1
Answer 2 / 3
hero85 Posts 7 Registration date Thursday March 12, 2009 Status Member Last seen May 14, 2009 8
Mar 19, 2009 at 04:05 PM
no, i dont think so. anyone else any ideas?
-1
Answer 3 / 3
hero85 Posts 7 Registration date Thursday March 12, 2009 Status Member Last seen May 14, 2009 8
Mar 19, 2009 at 04:05 PM
no, i dont think so. anyone else any ideas?
-1

Similar discussions

Why can't I bridge connect?
ryno -
Qiqi -

15 responses
Hi Guys how to create an account for facebook with my company em
Ramu -
Ahmadzai -

2 responses
Yahoo account reactivation
Senkumba -
kitkat55 -

2 responses
How to bridge connections from laptop to pc
TEchNoob -
Nilesh Katekar -

13 responses