Named range for chart: Offset and rows.

[Geir Hogstad]

Hi,

I am trying to use a dynamic range for my chart. I made it work once, but now i can not repeat it.

Using the formula =Offset($K$7;0;0;ROWS(K7#);1)

and copy that ino the name refference

Screen picture: Forskyvning=Offset Rader=Rows

Attached excample file.

Any solution.

Best Regards

- Geir

[#2]

@Geir Hogstad 

You didn't fix the reference

Use $K$7 instead, with that it works

[#3]

Thank you @Sergei Baklan it worked perfekt

- Geir