Hello,

I want to create a Chart that does not directly reference cell-ranges (i.e.
A1:A6),
but excel-names that make the reference sheet-independent.
My aim is to be able to copy one chart to other worksheets, which have their
dataareas at the same places like the source-sheet.

Problem: This works fine in cells but not in charts
Excel name definition:
=INDIRECT("R3C2";0):INDIRECT("R3C5";0)

Any idea about this?

Thanks in advance,
Holger.