Jun 13, 16 · There seems to be a lot of threads on using the INDIRECT function with Named Ranges however I cannot seem to get my sheet working despite following recommendations I have created two named ranges 'x' and 'y' 'x' points to the cell references found at H22I22 with the 'INDIRECT' function, selecting the range I wish to chartJun 26, 16 · Named range use in chart series formulas causes errors if named range was created via VBA code I have ID'd a bug in Excel 13 where named ranges created via VBA code (NamesAdd method), and those created manually, are somehow different when those named ranges are used in chart series formulasDo not directly use the named range as the data source for the chart If you enter the named range "MyRange" as the Source Data Data Range for the chart, Excel will automatically convert the named range into an actual range Any future changes to your named range will therefore not update your chart
Excel Dynamic Range Offset Formula Exclude N A Stack Overflow