Here's my 2¢:

The only reason Excel put the Smoothed Lines feature into the charts is so
management slides look nice. Using smoothed lines is potentially misleading,
particularly if the data points are not indicated with markers. Use straight
lines connecting the points and avoid misrepresentation of the gaps between
the actual data.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

"ile" wrote in message
...
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.