How can i use a name range in graphics?

%3CLINGO-SUB%20id%3D%22lingo-sub-1590794%22%20slang%3D%22es-ES%22%3EHow%20can%20i%20use%20a%20name%20range%20in%20graphics%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1590794%22%20slang%3D%22es-ES%22%3E%3CP%3EHi%20everyone!%3C%2FP%3E%3CP%3EI'm%20using%20Excel%20365%20in%20spanish.%3C%2FP%3E%3CP%3Eand%20i'm%20trying%20to%20use%20a%20name%20range%20into%20a%20series%20of%20the%20graph%20to%20make%20it%20dynamic%20but%20have%20tried%20everything%20and%20it%20doesn't%20accept%20it.%3C%2FP%3E%3CP%3EI've%20press%20F3%20to%20include%20them%2C%20have%20written%20by%20myself%2C%20etc.%20and%20doesn't%20work.%3C%2FP%3E%3CP%3ESomebody%20can%20help%20me%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1590794%22%20slang%3D%22es-ES%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1591163%22%20slang%3D%22en-US%22%3ERe%3A%20How%20can%20i%20use%20a%20name%20range%20in%20graphics%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1591163%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F760638%22%20target%3D%22_blank%22%3E%40CucoTorres%3C%2FA%3E%26nbsp%3BYou%20need%20to%20use%20dynamic%20named%20ranges.%20Google%20offers%20many%20links%20that%20describe%20how%20to%20create%20dynamic%20named%20ranges%2C%20most%20using%20OFFSET.%20But%20you%20can%20also%20build%20your%20graph%20based%20on%20a%20structured%20table.%20The%20attached%20workbook%20demonstrates%20the%20difference%20between%20the%20use%20of%20static%20references%20(will%20not%20automatically%20expand)%2C%20use%20of%20a%20structured%20table%20and%20dynamic%20named%20ranges.%20The%20formula%20I%20used%20to%20create%20the%20dynamic%20range%20comes%20from%20a%20book%20on%20PowerQuery%2C%20by%20Ken%20Puls%20and%20Miguel%20Escobar%20%22M%20is%20for%20(DATA)%20MONKEY%22%20and%20does%20not%20use%20the%20OFFSET%20function.%20Depending%20on%20the%20structure%20of%20your%20data%2C%20choose%20whichever%20works%20best.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Hi everyone!

I'm using Excel 365 in spanish.

and i'm trying to use a name range into a serie of the graph to make it dynamic but have tried everything and it doesn't accept it.

I've press F3 to include them, have written by myself, etc. and doesn't work.

Somebody can help me?

1 Reply

@CucoTorres You need to use dynamic named ranges. Google offers many links that describe how to create dynamic named ranges, most using OFFSET. But you can also build your graph based on a structured table. The attached workbook demonstrates the difference between the use of static references (will not automatically expand), use of a structured table and dynamic named ranges. The formula I used to create the dynamic range comes from a book on PowerQuery, by Ken Puls and Miguel Escobar "M is for (DATA) MONKEY" and does not use the OFFSET function. Depending on the structure of your data, choose whichever works best.