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
Highlighted
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
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies