Home

2 series trend line

%3CLINGO-SUB%20id%3D%22lingo-sub-666001%22%20slang%3D%22en-US%22%3E2%20series%20trend%20line%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-666001%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20there%2C%20I%20have%20a%20scatterplot%20composed%20of%20two%20data%20series-%20meaning%20I%20have%20two%20different%20colors%20sets%20of%20data%20points.%20I%20need%20a%20single%20trend%20line%20that%20is%20graphed%20as%20if%20the%20two%20data%20series%20are%20one.%20I%20have%20looked%20around%20searching%20for%20a%20solution%20and%20heard%20the%20function%20'SERIES'%20could%20be%20of%20use%2C%20but%20am%20unsure%20of%20how.%20Any%20ideas%20of%20how%20to%20use%20'SERIES'%20to%20resolve%20this%20problem%20or%20how%20another%20way%20this%20could%20be%20done%3F%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-666001%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECharting%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20Online%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-666951%22%20slang%3D%22en-US%22%3ERe%3A%202%20series%20trend%20line%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-666951%22%20slang%3D%22en-US%22%3EI%20think%20you%20should%20be%20looking%20into%20a%20different%20solution.%20A%20trendline%20is%20always%20tied%20to%20the%20series'%20data%20so%20if%20you%20need%20the%20trendline%20to%20be%20calculated%20against%20a%20different%20set%20of%20data%2C%20you%20would%20best%20use%20the%20existing%20worksheet%20functions%20to%20calculate%20the%20trendlines'%20parameters%20using%20e.g.%20the%20LINEST%20or%20SLOPE%20and%20INTERCEPT%20functions.%3C%2FLINGO-BODY%3E
etamer
New Contributor

Hi there, I have a scatterplot composed of two data series- meaning I have two different colors sets of data points. I need a single trend line that is graphed as if the two data series are one. I have looked around searching for a solution and heard the function 'SERIES' could be of use, but am unsure of how. Any ideas of how to use 'SERIES' to resolve this problem or how another way this could be done? 

1 Reply
I think you should be looking into a different solution. A trendline is always tied to the series' data so if you need the trendline to be calculated against a different set of data, you would best use the existing worksheet functions to calculate the trendlines' parameters using e.g. the LINEST or SLOPE and INTERCEPT functions.
Related Conversations
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
2 Replies
Early preview of Microsoft Edge group policies
Sean Lyndersay in Discussions on
65 Replies
*Updated 9/3* Syncing in Microsoft Edge Preview Channels
Elliot Kirk in Articles on
202 Replies