Forum Discussion
Hogstad_Raadgivning
Oct 19, 2020Steel Contributor
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
2 Replies
- SergeiBaklanDiamond Contributor
- Hogstad_RaadgivningSteel Contributor
Thank you SergeiBaklan it worked perfekt
- Geir