Dynamic named ranges in Charts

[xenou]

It's interesting that I can add a dynamic named range as a source for a chart series:
=Sheet1!Sales

But, not this way:
=Sales

It is as if charts cannot recognize global names in the same way that worksheets do. Does anyone know why this is so?

ξ

 

[SydneyGeek]

I've had the same experience with both charts and userforms.
I always point back to the worksheet first, then the range. If I don't the code doesn't recognise the range name; usually it fails silently.

I assume that it's because charts and userforms don't natively recognise worksheets; they're not the same kind of object, so you have to specifically identify the sheet.

Denis