Dynamic Ranges Lost on File save

[wratpack]

Hi, I'm having a problem with named ranges in a chart. I'm using Excel 2007 in Windows XP.

I have a multiple charts with different series all using dynamic named ranges. The dynamic ranges work perfectly until I save the file exit and re-open. Then the range name is changed to the format below.

Series values:
=[0]!range1

I've tried changing the scope from workbook to worksheet with no success.

Can anyone explain this? I've done similar things in other spreadsheets without probelm.

Thanks

 

[JLGWhiz]

Hi, I'm having a problem with named ranges in a chart. I'm using Excel 2007 in Windows XP.

I have a multiple charts with different series all using dynamic named ranges. The dynamic ranges work perfectly until I save the file exit and re-open. Then the range name is changed to the format below.

Series values:
=[0]!range1

I've tried changing the scope from workbook to worksheet with no success.

Can anyone explain this? I've done similar things in other spreadsheets without probelm.

Thanks

How are your named ranges populated?

 

[wratpack]

How are your named ranges populated?

Just a sime dynamic range using offset (). In most cases tje offset orihin os another range, and just offserting a number of rows down.

 

[wratpack]

I'll translate the last reply!
They are simple dynamic ranges using the offset(origin, R,C) funtion. The origin is another dynamic range (offset(x,0,0,counta(),1)). I.e start with a dynamic range and then offset from that by gong down rows in the sheet to select chart data.

From other info I have found I changed the scope of the named range from workbook to a specific sheet. This fixed the =[0]!range1
issue but now the charfts do not update despite the dynamic range working perfectly. When yiou select chart data and end it series the correct data is highlighted but does not display on the chart?