How to make a graph that change according to current date ?

[Pardoxxy]

I would like to create a simple graph that changes according to the current date.
So I have two values that are added in a "Total" cell, lets say for example : B4 = 75 and B5 = 50, so the the "Total" cell would be 125. And the graph I want would show the time evolution of this "Total" value, but I don't want to add a new row, type the current date and type the current Total each time my Total value changes. So I would like to know if it is possible (and how) to make a line graph that updates every time the Total value changes to show the evolution of this value.

 

[severynm]

Welcome!

It's literally not possible to do what you are asking. You want to plot a value over time but have only one value. The values over time have to be somewhere, they might be on a different sheet or hidden columns, but in order to plot anything they simply must be there.

You could end up with a small solution where you enter the values you want, press a button, and it appends the date and the total to the range for the chart to display.