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.
Configuration: Windows XP Internet Explorer 6.0