How do I prevent smooth curve in Excel from going below 0 on a graph? I need a smooth curve because I don't have enough data points, it looks terrible as a straight line. As you can see on this graph two of the data series goes below 0, even though none of the data points are 0.
I don't want to split it into 2 data series, that wouldn't make any sense as it would show up as 2 items in the legend.
41 Answer
'Smooth Curves' in Excel are really fitted polynomial, logarithmic, or other functions of various types. They are mathematically calculated, and depending of the type you chose, the result is what you get.
You should be able to right click each curve and choose another type of 'smoothing'; that way, you might be able to find one that looks better to you. I think it should work for sure to use sliding averages (but that curve might have other effects you might not like).
Potentially, there is no curve that fits your need; the only way to fake one then is to modify the respective data point to make it look nicer.
1
