cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Choose Language Hide Translation Bar
Ake
Ake
Level III

Progression per year, with date axis for several years overlayed

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!

Ake_2-1692108797615.png

 

 

 

2 REPLIES 2

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

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

  1. Add a new formula column for Month
  2. Change Day of Year[Date] to Ordinal
  3. 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.

Jed_Campbell_0-1692111797222.png

 

Thierry_S
Super User

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

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

Thierry_S_0-1692112502430.png

Best,

TS

Thierry R. Sornasse