Now I need to add 2 linear regression lines in the chart. I tried adding a new expression using linest_m function and changing the display option as line but for some reason, the regression line is not being displayed..
Am I missign anything? If anyone has a sample prototype that shows scatter chart with regression lines and can share it, that would be very helpful!
Re: Linear Regression lines inside a scatter chart
OK, I found the example I mentioned, and it's pretty similar to what you're doing. In the example, I calculated lines at 110% of the trend line and 90% of the trend line, but hopefully you can modify the line calculations to get your intended result. If you have trouble, I can take a closer look as what I did and how to adapt it.
Edit: Hmmm, I didn't even notice - I'm simulating a scatter chart with a line graph. Interesting.