SOLVED
Home

How do remove data points on a graph and keep the trendline for the same data points?

%3CLINGO-SUB%20id%3D%22lingo-sub-281947%22%20slang%3D%22en-US%22%3EHow%20do%20remove%20data%20points%20on%20a%20graph%20and%20keep%20the%20trendline%20for%20the%20same%20data%20points%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-281947%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20705px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F58982i49701F10D4BDCF3F%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Capture.PNG%22%20title%3D%22Capture.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20want%20to%20keep%20the%20blue%20data%20points%2C%20remove%20the%20orange%20data%20points%20but%20keep%20the%20orange%20trendline%3F%3C%2FP%3E%3CP%3EThank%20you%20in%20advance!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-281947%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-282560%22%20slang%3D%22en-US%22%3ERe%3A%20How%20do%20remove%20data%20points%20on%20a%20graph%20and%20keep%20the%20trendline%20for%20the%20same%20data%20points%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-282560%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Wyn%2C%3C%2FP%3E%3CP%3EThank%20you%20so%20much%20-%20it%20worked!%3C%2FP%3E%3CP%3EI%20really%20appreciate%20your%20help!%3C%2FP%3E%3CP%3EWill%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-282104%22%20slang%3D%22en-US%22%3ERe%3A%20How%20do%20remove%20data%20points%20on%20a%20graph%20and%20keep%20the%20trendline%20for%20the%20same%20data%20points%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-282104%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20William%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EAre%20those%20DATA%20Points%20markers%20in%20your%20chart%3F%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3Eif%20so%20you%20can%20right%20click%20on%20the%20line%20and%20choose%20format%20data%20series%20-%20Marker%20-%20None%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F59029i806389AB5B1D3215%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%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-281989%22%20slang%3D%22en-US%22%3ERe%3A%20How%20do%20remove%20data%20points%20on%20a%20graph%20and%20keep%20the%20trendline%20for%20the%20same%20data%20points%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-281989%22%20slang%3D%22en-US%22%3E%3CP%3EI%20want%20to%20keep%20TRENDLINE%20but%20delete%20orange%20DATA%20points%20%2C%20whilst%20keeping%20blue%20data%20points.%26nbsp%3B%3C%2FP%3E%3CP%3EI%20can%20change%20trendline%20to%20no%20outline%20but%20that%20would%20just%20hide%20the%20trendline%20and%20not%20the%20data%20points%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-281973%22%20slang%3D%22en-US%22%3ERe%3A%20How%20do%20remove%20data%20points%20on%20a%20graph%20and%20keep%20the%20trendline%20for%20the%20same%20data%20points%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-281973%22%20slang%3D%22en-US%22%3ECan%20you%20make%20the%20outline%20colour%20of%20the%20Orange%20Line%20as%20%22no%20outline%22%20%3F%3C%2FLINGO-BODY%3E
William Powell
New Contributor

Capture.PNG

 

I want to keep the blue data points, remove the orange data points but keep the orange trendline?

Thank you in advance!

4 Replies
Can you make the outline colour of the Orange Line as "no outline" ?

I want to keep TRENDLINE but delete orange DATA points , whilst keeping blue data points. 

I can change trendline to no outline but that would just hide the trendline and not the data points

Solution

Hi William

 

Are those DATA Points markers in your chart?

 

if so you can right click on the line and choose format data series - Marker - None

 

image.png

Highlighted

Hi Wyn,

Thank you so much - it worked!

I really appreciate your help!

Will

 

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
16 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
11 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
*Updated 9/3* Syncing in Microsoft Edge Preview Channels
Elliot Kirk in Articles on
217 Replies