[Solved] Use date format for the dates and use the xy scatter plot

I have the dates and weights for the times I was weighed at my doctor’s office. I would like to plot those so that the actual slopes are visualized.

I tried just putting the numbers in two columns and plotting them with a line plot but the days between the dates are irregular, sometimes 3 or more months elapse, sometimes only a week or two, but the dates on the graph are evenly spaced.

Is there a setting that will space the dates out to account for the number of days between dates, so I can see how well my diet is working?

  • Chais
    link
    fedilink
    arrow-up
    1
    arrow-down
    2
    ·
    1 year ago

    Did you change the type of the date column to date? It sounds like it’s used as a string, which means it is used as categorical data.