Invert Trendline Formula

The simplest way to "invert" the trendline is to switch the dependent and independent variables. In other words, create a series with X1:X100 for the y-axis and Y1:Y100 for the x-axis. Choose the simplest trendline that has a reasonably good RSQ, albeit maybe not the best RSQ. The trendline will always read y=...x... Just "translate" x to mean Y1:Y100 and y to mean X1:X100.

If you do choose a high-degree polynomial to fit your data, beware that it is probably only useful for interpolating data points. Such formulas tend to "blow up" when you try to extrapolate them.

Hey guys,

Thanks so much for all of your help. I looked at all of your options. For the time being I just switched my X and Y axis (how did I not think of that before lol)

I will, however, look at the article about over fitting the trendline.

Thanks so much again!