Using Trend line with line chart

[sraj]

Hi everyone,

I have a column which has data 'YearMonth' in the same column for several years, is there anyway I can show the Trend line.  For example 2020-04 & 2021-04 above each other instead of continous like what I have on my picture?

Please advise.

Thank you!

[amitchandak]

@sraj , Based on what I got so far. 

if you have a numeric year month(YYYYMM), you will get a continuous axis(Axis type)  option. or you can get that on date