Changing values in Source Data

dee_seal

New Member
Joined
Nov 14, 2002
Messages
2
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
 

Some videos you may like

Excel Facts

Create a Pivot Table on a Map
If your data has zip codes, postal codes, or city names, select the data and use Insert, 3D Map. (Found to right of chart icons).

IML

MrExcel MVP
Joined
Feb 15, 2002
Messages
1,743
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

New Member
Joined
Nov 14, 2002
Messages
2
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

MrExcel MVP
Joined
Feb 15, 2002
Messages
1,743
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).
 

Watch MrExcel Video

Forum statistics

Threads
1,123,139
Messages
5,599,958
Members
414,352
Latest member
macquarie_jchan58

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top