I am trying to use numbers to plot a chart of my electricity consumption. I have a table that looks like:
As you can see the X axis is regularly spaced: the 4 points are equally distant and one could infer that the consumption is simply linear.
From this graph I can detect that there is an acceleration of consumption between the 15th and 17th of January. In other words, the second graph is drawing each point in the right moment in time.
Is there an option to do this automatically without having to add every single day of the year (or hours, in other use cases) to a column?