Named range for chart: Offset and rows.

%3CLINGO-SUB%20id%3D%22lingo-sub-1795336%22%20slang%3D%22en-US%22%3ENamed%20range%20for%20chart%3A%20Offset%20and%20rows.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1795336%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20trying%20to%20use%20a%20dynamic%20range%20for%20my%20chart.%20I%20made%20it%20work%20once%2C%20but%20now%20i%20can%20not%20repeat%20it.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EUsing%20the%20formula%20%3DOffset(%24K%247%3B0%3B0%3BROWS(K7%23)%3B1)%3C%2FP%3E%3CP%3Eand%20copy%20that%20ino%20the%20name%20refference%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EScreen%20picture%3A%20Forskyvning%3DOffset%20Rader%3DRows%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22named%20range.PNG%22%20style%3D%22width%3A%20983px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F227698iA4A3DBF73814444A%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22named%20range.PNG%22%20alt%3D%22named%20range.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EAttached%20excample%20file.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20solution.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBest%20Regards%3C%2FP%3E%3CP%3E-%20Geir%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1795336%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1796205%22%20slang%3D%22en-US%22%3ERe%3A%20Named%20range%20for%20chart%3A%20Offset%20and%20rows.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1796205%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F9195%22%20target%3D%22_blank%22%3E%40Geir%20Hogstad%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%20didn't%20fix%20the%20reference%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20407px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F227742i67A01C178029A906%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3EUse%20%24K%247%20instead%2C%20with%20that%20it%20works%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20480px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F227743iEC3A5B43026D0B00%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Frequent Contributor

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

named range.PNG

Attached excample file.

 

Any solution.

 

Best Regards

- Geir

2 Replies
Highlighted

@Geir Hogstad 

You didn't fix the reference

image.png

Use $K$7 instead, with that it works

image.png

Highlighted

Thank you @Sergei Baklan it worked perfekt

- Geir