Setting an intercept for a trend line

[Anonymous]

Hello,

I am trying to create trend lines in a scatter chart. Unfortunately these trends are not helpful unless the y-intercept can be set at y=0. Is there any way to create trend lines with intercept conditions?

Thank you

[v-yuta-msft]

@Anonymous ,

You can set the start position of Y-axis in the format pane like below:

 

Community Support Team _ Jimmy Tao

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

[Anonymous]

@v-yuta-msft ,

Thank you for your reply but this is not what I meant.

I would like to set an intercept on the trend line analytics such that each line crosses the origin (0,0) point. Currently, trend lines are only showing best fit linear regressions that don't take intercepts into account. I have attached a screenshot to show what I mean:

Thank you

[v-yuta-msft]

@Anonymous ,

I would suggest you use Python/R visual instead in this senario.

Community Support Team _ Jimmy Tao

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