Hi all,

I've set up a dynamic named range called 'Res_Code_Chart_Data', using an Offset formula: "=OFFSET(Incidents!$U$43,0,0,COUNTA(Incidents!$U$43:$U$53),2)"

The range grows and shrinks dynamically as expected when I add and remove data. I want to use the range as the data source for a chart. But, when I enter a reference to the named range as the Chart Data Source "=Incidents!Res_Code_Chart_Data", Excel immediately resolves the reference to the absolute reference 'Incidents!$U$43:$U$52". After that, when data is added or removed and the named range grows or shrinks, the chart continues to only pull data from the absolute ref the named range represented when originally created.

Any advice on this issue, much appreciated. I'm using Excel 2010.

Jamsta.