How can I get a smoothing line like Excel?

9 ビュー (過去 30 日間)
Sam Cao
Sam Cao 2020 年 11 月 18 日
コメント済み: Sam Cao 2020 年 11 月 18 日
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,


Nora Khaled
Nora Khaled 2020 年 11 月 18 日
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...
  1 件のコメント
Sam Cao
Sam Cao 2020 年 11 月 18 日
Thank you very much.


その他の回答 (0 件)


Help Center および File ExchangePreprocessing Data についてさらに検索

Community Treasure Hunt

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

Start Hunting!

Translated by