Hi,

Using Excel 2007.

I'm using a dynamic data sources on a chart using named regions. I have a
name region called 'Bob' which is as follows:

=OFFSET('Sheet1'!$B$2,0,0,COUNT('Sheet1'!$B$2:$B$2 4),1)

and the Series Values in my chart is:

='my workbook.xlsx'!Bob

Everything works ok until i save, close and re-open the workbook.

The Series Values formula changes to

=[0]!Bob

and therefore no longer works when the data changes

Does anyone have any idea why this happens and/or how to fix it?

Thanks.