Trouble with defined named range

[BRISBANEBOB]

Hi

I am trying to create a zoom and scroll chart and trying to follow the instructions below I cannot create a named range called =OFFSET(C2, 0, 0, $D$1, 0). I suspect it is because you cannot create a named range that uses a Function name. If this is the case, what would the writer have meant?

Create a Dynamic Named Range
Step 1
Repeat Step 2 from "Create a Variable Data Range" to find a new range the same size as the two previous ones. A range containing cells D2 to D802 is the same size as the example's previous two ranges.
Step 2
Select all the cells in this new range.
Step 3
Click "Formulas" in the program's ribbon. Click "Define Name" in the Defined Names group to open the New Name dialog box.
Step 4
Type the following formula into the text box labeled "Name": =OFFSET(A1, 0, 0, $D$1, 0)
Step 5
Replace "A1" in the formula with the first cell from the second range. With this example, change the formula to: =OFFSET(C2, 0, 0, $D$1, 0)
Step 6
Replace "$D$1" with the address of a new blank cell. Later, the zoom bar will change this cell's value. For example, to choose cell F10 for this purpose, change the formula to: =OFFSET(C2, 0, 0, $F$10, 0)
Step 7

[martindwilson]

i should think that
=OFFSET(A1, 0, 0, $D$1, 0) goes in the refers to box
having said that
where does this instruction come from,what's the url. it maybe you've missed a previous step/instruction
ah is it this?
http://smallbusiness.chron.com/add-z...art-41823.html

[BRISBANEBOB]

Thanks for the response. I suspect this now should be in the Charting forum.

That is the site and I've attached the file I am trying to create.

Any help much appreciated

[jeffreybrown]

I see nothing as to instructions within this file. What are you trying to do?

[BRISBANEBOB]

This part:

Create a Dynamic Named Range
Step 1
Repeat Step 2 from "Create a Variable Data Range" to find a new range the same size as the two previous ones. A range containing cells D2 to D802 is the same size as the example's previous two ranges.
Step 2
Select all the cells in this new range.
Step 3
Click "Formulas" in the program's ribbon. Click "Define Name" in the Defined Names group to open the New Name dialog box.
Step 4
Type the following formula into the text box labeled "Name": =OFFSET(A1, 0, 0, $D$1, 0)
Step 5
Replace "A1" in the formula with the first cell from the second range. With this example, change the formula to: =OFFSET(C2, 0, 0, $D$1, 0)
Step 6
Replace "$D$1" with the address of a new blank cell. Later, the zoom bar will change this cell's value. For example, to choose cell F10 for this purpose, change the formula to: =OFFSET(C2, 0, 0, $F$10, 0)
Step 7

[martindwilson]

jb see link in post #2

[BRISBANEBOB]

Hi JB

Thanks - I am proceeding on that basis.

Just to confirm, the instructions to insert the =OFFSET(etc. in the Name box is incorrect? You can't do it because you are trying to use a function code Excel reserves for itself?

[jeffreybrown]

Yes, that is right as Martin pointed out in post #2 (by the way, not crazy about that website and there instructions).

You may find this interesting.