Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Reference Data Range based on cell contents
I have a chart in which the Data range is set as follows:
='Sheet2'!$A$25:$M$37 Is it possible to do the following? Where it states "$M$37", I'd like "37" to be based on a number that shows in AB1. Is that possible? Thanks, Paul |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Match function...random search? | Excel Worksheet Functions | |||
Possible Lookup Table | Excel Worksheet Functions | |||
Cell Reference Math | Excel Worksheet Functions | |||
How can I shift cell range contents by using a function? | Excel Worksheet Functions | |||
GET.CELL | Excel Worksheet Functions |