Hi evryone,

I couldn't find any help on this topic up to now.

I have to cells which contain the staring and end point (row number) based on which in other cells an adress is created. e.g:

Cell_A = 10
Cell_B = 20
Cell_C = Sheet!$A$10:$A$20

How can I reference the data of the chart to Cell_C? Is there any way to do so? I always get the message UNallowed reference or similar (mine is in German).

Thanks in advance for any help!

Cheers,

Lukas