Changing values in Source Data

[dee_seal]

I am trying to dynamically change the values in the source data of a chart.
in the values box I highlight sheet1 cells F7 to U7
it looks like this "=SHEET1$F$7:$U$7"
I want to reference a cell (CELL A2) with Concatenations resulting in a text with this in the cell A2 "=SHEET1$F$7:$U$7"
so within the values box of a chart I want to reference Cell A2. Is there any function that can do this such that the text in cell A2 will resolve as the range for the values. so if my data range were to increase by one column all i need to change is teh value in Cell A2 to "=SHEET1$F$7:$V$7"

Thanks

DN

 

[IML]

in the cell A2 "=SHEET1$F$7:$U$7"

Change a2 to
SHEET1$F$7:$U$7
When you want to call this range, refer to
=indirect(a2)
instead of just a2.

 

[dee_seal]

On 2002-11-16 12:22, IML wrote:

in the cell A2 "=SHEET1$F$7:$U$7"

Change a2 to
SHEET1$F$7:$U$7
When you want to call this range, refer to
=indirect(a2)
instead of just a2.

Thanks, I tried it but the problem did not get solved
A pop up window appears that says
"that function is not Valid"
If you figure itout let me know I am really hurting with this thing
DN

 

[IML]

List the formula as it works properly
ie(=vlookup(a1,A10:b20,2,0))
and say what part you want to replace
(ie a10:b20 with a reference in cell b1).