Get values for a new line on a graph

Question

I have an Excel sheet where every day I add a new line with the values of the Brent quotation and other indicators. These same values are then updated in a line chart.

It turns out that whenever I add a new line, the values of it are not inserted in the chart because they are not part of the crease of the formula on the graph.

Is there any way to get the new line information automatically without having to reconfigure the chart to the new crease?

This formula is inserted in the graph

=Energias!$A$1:$C$417;Energias!$J$1:$Q$417;Energias!$T$1:$V$417

When I add a new line the graph formula looks like this:

=Energias!$A$1:$C$1;Energias!$A$3:$C$418;Energias!$J$1:$Q$1;Energias!$J$3:$Q$418;Energias!$T$1:$V$1;Energias!$T$3:$V$418

Answer 1

Hello

You can create a Range with Shift.

Suppose you have the situation below

You can create a field through the name manager

Using the formula

=DESLOC(Planilha1! $A$2;0;0;CONT.NÚM(Planilha1! $A:$A);1)

Then just put the name you chose in my case I used "Test" in the series you want

The following graph became dynamic. Each value typed in column A will be automatically replicated to the graph.