| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Data range reference in a cell
Hi
I'm working with a large number of data ranges and i want to be able to change the source data of one chart by typing the range name in a cell rather than directly into the chart source tab. For example: in B1 i've typed "SCK" (which is defined as a range on another sheet) I want to be able to change B1 to read "JAB" and the chart to change it's source data to the JAB range which is also defined. Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copying cell names | Excel Discussion (Misc queries) | |||
| Match function...random search? | Excel Worksheet Functions | |||
| how do i reference data in a file with the fname in another cell? | Excel Worksheet Functions | |||
| Can a conditional cell formula reference data selection in a comb. | Excel Worksheet Functions | |||
| highlight range if cell contains desired data | New Users to Excel | |||
Threaded Mode
