my chart can not smooth the points

%3CLINGO-SUB%20id%3D%22lingo-sub-968187%22%20slang%3D%22en-US%22%3Emy%20chart%20can%20not%20smooth%20the%20points%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-968187%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20trying%20to%20create%20a%20chart%20of%20smoothed%20points%20.%20I%20choose%20the%20correct%20chart%20type%20but%20the%20chart%20still%20only%20shows%20unsmoothed%20points.%20It%20might%20be%20crucial%20to%20let%20you%20know%20that%20the%20table%20containing%20the%20data%20points%20has%20a%20column%20of%20non-continuous%20cells%2C%20some%20cells%20are%20empty%2C%20however%20I%20merged%20those%20cells%20with%20the%20filled%20ones%20but%20the%20problem%20still%20persists.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-968187%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3Echart%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Esmooth.%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-970536%22%20slang%3D%22en-US%22%3ERe%3A%20my%20chart%20can%20not%20smooth%20the%20points%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-970536%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F437127%22%20target%3D%22_blank%22%3E%40inadotb%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhen%20you%20say%20%22smoothed%20points%22%2C%20do%20you%20mean%20you%20want%20the%20line%20to%20be%20%22smoothed%22.%20You%20can%20do%20that%20by%20selecting%20the%20line%20of%20the%20Data%20Series%20you%20want%20smoothed.%20Choose%20%22Format%20Data%20Series%22.%20Somewhere%20in%20the%20following%20screen(s)%2C%20you%20should%20find%20the%20option%20%22Smoothed%20Line%22.%20I'm%20on%20a%20Mac%20and%20my%20screens%20probably%20look%20different%20from%20yours.%20If%20this%20doesn't%20solve%20it%2C%20please%20attach%20a%20workbook%20with%20some%20sample%20data%20and%20a%20chart%20that%20demonstrates%20your%20issue.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-977875%22%20slang%3D%22en-US%22%3ERe%3A%20my%20chart%20can%20not%20smooth%20the%20points%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-977875%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F437127%22%20target%3D%22_blank%22%3E%40inadotb%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIf%20you%20mean%20to%20ignore%20empty%20cells%2C%20merging%20of%20them%20won't%20help%20(in%20general%20it's%20better%20to%20avoid%20cell%20merging%20at%20all).%20You%20may%20right%20click%20on%20your%20chart%2C%20select%20data%20and%20here%20in%20options%20for%20hidden%20data%20select%20connection%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20305px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F154587iF9D51EA0DA9BCCEA%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22image.png%22%20title%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3Eif%20that's%20what%20do%20you%20mean%20under%20smoothing.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

I am trying to create a chart of smoothed points . I choose the correct chart type but the chart still only shows unsmoothed points. It might be crucial to let you know that the table containing the data points has a column of non-continuous cells, some cells are empty, however I merged those cells with the filled ones but the problem still persists.

2 Replies
Highlighted

@inadotb 

When you say "smoothed points", do you mean you want the line to be "smoothed". You can do that by selecting the line of the Data Series you want smoothed. Choose "Format Data Series". Somewhere in the following screen(s), you should find the option "Smoothed Line". I'm on a Mac and my screens probably look different from yours. If this doesn't solve it, please attach a workbook with some sample data and a chart that demonstrates your issue.

 

 

Highlighted

@inadotb 

If you mean to ignore empty cells, merging of them won't help (in general it's better to avoid cell merging at all). You may right click on your chart, select data and here in options for hidden data select connection

image.png

if that's what do you mean under smoothing.