dynamic range with chart

[TonyNguyen]

Hi guys,

I'm trying to create a global dynamic range for my charts which works ok however the problem i have is that the range name only work for one worksheet.

Attached is the file which I have the first 2 charts with dynamic name, and when i tried to use the same range name in other sheets, i couldn't as it will refer back to the first chart range. I tried to remove the Sheet reference but still doesnt work.

Please help.

Thanks in adv.