Hi
I have a curious problem with interpolated data. My data is particle size
distribution (0-100%), where the last proportion is added to next. The last
values are about 97% and after that are 2-3 blank cells before the maximum
value 100%.

I have plotted the data into XY-scatter chart and interpolated the empty
cells with smoothed lines. The interpolation gives curves that go above 100%
after the said 97% value and return to the maximum 100% in the end. The
interpolation is ok with straight lines, but this way the presentation is not
quite accurate.

My question is that is it possible to set maximum value for interpolated
values i.e. 100%? Please advise.