xy scatter line goes below zero

[jon7]

The line drawn in my xy scatter chart goes below zero of the y-axis, is there
any way I can stop this? My first 3 points are all zero and then there is a
very steep increase, the line that connects them assumes that there is a dip
into negative values before the increase when this is not actually the case.

 

[Andy Pope]

Hi,

Have you got the Smooth line option ticked?

Cheers
Andy

 

[jon7]

hello,
thanks for the tip, I have selected smooth line and that's right when it's
above zero, the non-smooth option isn't a great representation of my curve
though, any other ideas?

 

[Andy Pope]

Remove those 3 points from the series and use another 3 point series to
replace them.