trend line with week and month names in X-Axis

[andreazambon]

Hi there, 

I have a graph with 3 levels of timedata, all putted in X axis: 

-month name (as text)

-week (as text, formatted as year.week (e.g. 2023.07)

-date (as date)

As values, I have some percentage. 

I need to insert in my graph a trend line, but i'm afraid that due to text format on month and week, this opportunity is not allowed. 

Any trick to manage this kind of stuff?

Thanks.

[amitchandak · Accepted solution]

@andreazambon , You can only get trend line, continuous line for date and number only so you keep week number YYYYWW you can get  

[andreazambon]

It works fine, thankyou!