I'm trying to do a linear trendline however, some of my data are zeros. So the trendline goes through the x axis and shows my y- axis at a negative number. How do I get the trendline to stop at the x- axis and not drop off? ( Please note I'm still a novice at Excel so big words and tons of formulas won't help me at all, KIS, keep is simple please.)
Bookmarks