I would like to build a line chart that automatically plots values for the
past 14 days, no matter when I open the chart.

I have set up a column with now() in the first cell and now()-1, now()-2,
etc. in a series for the following 13 cells down to now()-14. This column
becomes the data range for the x-axis.

If I test it by changing the system date, the now() values do not change
automatically. I know there must be a way to do that.

But the further concern is how to link values in another column with the
proper
now()-x value to display what I want to see.

I want to use this chart to be able to show my doc my sugar glucometer
readings for two weeks, whenever I open the chart.

Thanks