Forum Discussion

Hogstad_Raadgivning's avatar
Hogstad_Raadgivning
Steel Contributor
Oct 19, 2020

Named range for chart: Offset and rows.

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