Clear Filters
Clear Filters

How can I get a smoothing line like Excel?

10 views (last 30 days)
Dear all,
I got some test data sets and ploted them in excel, the following image is the result.
Left : no smoothing, just connecting each data with direct lines.
Right : connecting each data with default Excel smoothing method.
Excel smoothing method works well.
But I tried some Matlab methods such as interp1, it seemed that they cannot work normally in my data sets.
In my opinion, the reason is that both x value and y value are not monotonous.
So are there any methods provided by Matlab library that can solve this problem?
Or any advice about what method Excel is using to plot a smoothing curve.
Best regards,

Accepted Answer

Nora Khaled
Nora Khaled on 18 Nov 2020
I tried the answer to this question
with your data
x = [-1 -.6 0 .6 1 .6 0 -.6];
y = [-0 .6 1 .6 0 -.6 -1 -.6];
I think it works...

More Answers (0)


Find more on Preprocessing Data in Help Center and File Exchange

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!