How can i use a name range in graphics?

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.