topic Progression per year, with date axis for several years overlayed in Discussions

Progression per year, with date axis for several years overlayed

Ake — Tue, 15 Aug 2023 14:16:42 GMT

I want to plot data as is progresses over the year, with one curve for each year overlaid. The way I made it so far is to use Day of year (see figure) but I would like actual dates like month-day instead. Any ideas would be welcome!

Re: Progression per year, with date axis for several years overlayed

Jed_Campbell — Tue, 15 Aug 2023 15:03:37 GMT

If you're looking just for a plot/graph, here's one way:

Add a new formula column for Month
Change Day of Year[Date] to Ordinal
Use Graph Builder to drag both date columns to the x axis. In the axis settings, I unchecked the "Show Tick Labels" box for the Day of Year axis.

Script saved to attached table.

Re: Progression per year, with date axis for several years overlayed

Thierry_S — Tue, 15 Aug 2023 15:15:37 GMT

Hi,

Here is a different approach to your problem.

1) I computed a new column capturing only the Day and Month from the Date column (continuous)

2) I created a custom Date Format DD/MM

3) I plotted this new column as X axis using a 4-week interval

Best,