Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Dynamic Range
Following on from previous questions I have posed I know I need to
create defined name with an Offset formula to drive a series within a chart. My problem is that the Offset reference is also variable (can be any month form Jan through to Dec) . The defined name formula I have come up with to do this is not accepted: =OFFSET('Data Sheet (2)'!ADDRESS(6+ (MATCH(VLOOKUP(eurosdate,AH7:AH18,1,FALSE),AH7:AH1 8,0)),34), 0,20,1,-20) If it helps, I have a formula in a worksheet ('Data Sheet' (2)!) that returns a Month, e.g. Feb. Using this outcome, I then need to look through a vertical list of months Jan to Dec, identify the matching month and use the data contained in x20 cells located immediately to the right of the selected month to drive a chart series contained on another worksheet (Europe!). Any help would be appreciated. Bob Nottingham UK |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dynamic Range | Charts and Charting in Excel | |||
dynamic range name | Excel Worksheet Functions | |||
Dynamic range | Excel Discussion (Misc queries) | |||
Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
dynamic range | Excel Discussion (Misc queries) |