I have a data set in which Y is an increasing function of X. Here is the data:
5 | 0.1
10 | 0.789
15 | 147.5
20 | 216.5
25 | 276.5
I create an XY (Scatter) Chart with Smooth Lines:
Because the first two points are very close in Y value, and not characteristic of the distribution of the other points, the smooth line option displays a 'dip' between those two points.
How can I plot this with a smoothed line that estimates the curve on which the data lie without having it include a dip?
Answer
Are you willing to manipulate (fudge) your data to get the desired chart? I was able to add one point:
5 0.1
9.9 0.7
10 0.789
15 147.5
20 216.5
25 276.5
and the chart changed to this:
No comments:
Post a Comment