Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Trend Line Max to 0

Hi, I've already seen some replies about trend lines but still didn't find the answer to my questions: 1 - Is it possible to do it? 2 - How can I do it?   I have 2 tables Date Value 01/01...
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Anonymous ,

     

    As far as I know, a trend line will only show a line parallel to the X-axis, not a downtrend line.

    I suggest you to create a calendar table and relate it with your data tables.

    Add the data column in Table1 into Secondary y-axis field. Result is as below.

     

    Best Regards,
    Rico Zhou

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Sorry Aman, cannot access your link. 😞