Search : in
By :

Using Named Ranges to create dymaic graphs

Last answer on Mar 19, 2009 8:05:28 pm GMT hero85, on Mar 18, 2009 6:32:34 pm GMT 
 Report this message to moderators

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

Best answers for « Using Named Ranges to create dymaic graphs » in :
Create a Skype account ShowCreate a Skype account How to create a Skype account? If you do not have Skype, download it and install it, the following window will appear after the installation finished: If Skype is already installed, run it and click Do not...
3D Graphics Software Show3D Graphics Software Art of Illusion Blender Pov Ray Calimax Modeller DAZ 3D Genesis 3D Editor GLC Player ZModeler Professional 3D computer-generated imagery created by studios like Warner Bros or Pixar are generated by 3D...
Creating an ISO image under Linux ShowCreating an ISO image under Linux Create ISO image(which we will name) a disc in a CD-ROM drive(/dev/cdrom) is quite simple : dd if=/dev/hdd of=mycd.iso
Partition - Partitioning a hard drive ShowWhat is a partition? The partitioning of a hard drive occurs after the drive has been physically formatted but before it is logically formatted. It involves creating areas on the disk where data will not be mixed. It can be used, for example, to...
Creating a local area network ShowWhy set up a local area network? When you have several computers, it can be convenient to connect them to each other to create a local area network (LAN). Setting up such a network costs very little, contrary to what people may think. Here are a...

1

keeprise, on Mar 19, 2009 9:23:09 am GMT

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.

Reply to keeprise

2

hero85, on Mar 19, 2009 8:05:28 pm GMT

No, i dont think so. anyone else any ideas?

Reply to hero85

3

 hero85, on Mar 19, 2009 8:05:28 pm GMT

No, i dont think so. anyone else any ideas?

Reply to hero85