Trend Line Max to 0

[Anonymous]

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/2023	1000
31/01/2023	0

Date	Value	Remaining
02/01/2023	100	900
09/01/2023	200	700
16/01/2023	500	200

My idea is to have a line chart using the data from the 2nd table (Date and Remaining), and a trend line using the data from the 1st table.

Thank you for your help.

[Anonymous · Accepted solution]

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]

Thank you

[amalsperera]

Hi @Anonymous ,

Please check if this is whet you are looking for.

https://drive.google.com/file/d/1pHQPKotvkbVpfmOj3Cy3t6F4MVmEENCo/view?usp=sharing

Amal

[Anonymous]

Sorry Aman, cannot access your link. 😞

[amalsperera]

Hi @Anonymous, Sorry about that. Please check wit hthe following link. https://drive.google.com/file/d/1pHQPKotvkbVpfmOj3Cy3t6F4MVmEENCo/view?usp=sharing Amal