Help with graph and data series

BarrettM · Mar 22nd, 2002, 07:16 AM

I'm trying to create a graph using data that is a named range . I gave the range a name as the data will not always be in the same place on the worksheet. How can I reference the range using the name?

Tommy Bak · Mar 22nd, 2002, 07:24 AM

Hi
each series will have to have their own name.
in the valuesbox of each series write the name of the workbook and the name.

=Book1!name

regards Tommy

BarrettM · Mar 22nd, 2002, 07:28 AM

Thank you so much Tommy, it worked a treat.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 22nd, 2002, 07:16 AM	#1
BarrettM Board Regular Join Date: Mar 2002 Location: Northern Ireland Posts: 113	I'm trying to create a graph using data that is a named range . I gave the range a name as the data will not always be in the same place on the worksheet. How can I reference the range using the name?

Mar 22nd, 2002, 07:24 AM	#2
Tommy Bak Board Regular Join Date: Feb 2002 Location: Guderup, Denmark Posts: 287	Hi each series will have to have their own name. in the valuesbox of each series write the name of the workbook and the name. =Book1!name regards Tommy

Mar 22nd, 2002, 07:28 AM	#3
BarrettM Board Regular Join Date: Mar 2002 Location: Northern Ireland Posts: 113	Thank you so much Tommy, it worked a treat.