how can I add the red line as shown in the example picture below?
Create an image file that has a straight line from the bottom left corner to the top right corner. Then add this image as Image to the scatter chart on the Colors tab in the Frame Background section.
Try this trick: in the expressions tab of the chart copy your first expression to make a new third expression identical to the first and add a linear trendline to that third expression.
I tried to implement your solution, but it did not draw anything on the scatter chart. Maybe because there were 3 expressions already (X/Y/Z) ?
This is what my technique can give:
could you post me an example project?
I would be forever grateful
Check this qvw.
Retrieving data ...