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
2nd Order Polynomial Curve-fit using Trend function
PA_Observer in Excel on
0 Replies
Vertical Line Charts
cookma423 in Excel on
7 Replies
Why can't I draw a straight line?
Maha Kanwal in Office 365 on
2 Replies
working on a series
MBARRY95 in Excel on
2 Replies