Forum Discussion
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/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.
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 ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
5 Replies
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 ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous ,
Please check if this is whet you are looking for.
https://drive.google.com/file/d/1pHQPKotvkbVpfmOj3Cy3t6F4MVmEENCo/view?usp=sharing
Amal
- Hi Anonymous, Sorry about that. Please check wit hthe following link. https://drive.google.com/file/d/1pHQPKotvkbVpfmOj3Cy3t6F4MVmEENCo/view?usp=sharing Amal
