# Specifying coefficients in trendline equation

#### vinny21

##### New Member
Hi all!

I would like to know if there is a way to set a coefficient in the trendline equation to zero.

For example:
The equation of the second order trendline is Ax^2 + Bx + C
I want to find a way to set B = 0

I know it's possible to set C = 0 by setting the intercept, so I was wondering if there was such a thing for other coefficients.

(the reason I want to do this is that I want to fit data to an equation where both the y and x intercepts are at zero)

Thanks

### Excel Facts

Select a hidden cell
Somehide hide payroll data in column G? Press F5. Type G1. Enter. Look in formula bar while you arrow down through G.

#### Jon Peltier

##### MrExcel MVP
"the reason I want to do this is that I want to fit data to an equation where both the y and x intercepts are at zero"

If the Y intercept is zero, that means the equation goes through (0,0), which means the X intercept is already zero.

Replies
9
Views
92
Replies
3
Views
152
Replies
2
Views
43
Replies
0
Views
72
Replies
1
Views
34