Previous Topic Next Topic

Using Named Ranges to create dymaic graphs

Closed
hero85 Posts 7 Registration date Thursday 12 March 2009 Status Member Last seen 14 May 2009 - 18 Mar 2009 à 14:32
hero85 Posts 7 Registration date Thursday 12 March 2009 Status Member Last seen 14 May 2009 - 19 Mar 2009 à 16:05
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

Réponse 1 / 3
keeprise Posts 11 Registration date Saturday 15 November 2008 Status Member Last seen 25 May 2009 1
19 Mar 2009 à 05:23
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.
Réponse 2 / 3
hero85 Posts 7 Registration date Thursday 12 March 2009 Status Member Last seen 14 May 2009 8
19 Mar 2009 à 16:05
no, i dont think so. anyone else any ideas?
Réponse 3 / 3
hero85 Posts 7 Registration date Thursday 12 March 2009 Status Member Last seen 14 May 2009 8
19 Mar 2009 à 16:05
no, i dont think so. anyone else any ideas?

Similar discussions

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

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

13 responses
cannot get my home pc to bridge connections
darrenrst -
corona_king -

3 responses