Home

How to create a Line Chart Trendline with multiple data series

%3CLINGO-SUB%20id%3D%22lingo-sub-359275%22%20slang%3D%22en-US%22%3EHow%20to%20create%20a%20Line%20Chart%20Trendline%20with%20multiple%20data%20series%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-359275%22%20slang%3D%22en-US%22%3E%3CP%3EI%20understand%20that%20scatter%20plots%20allow%20trendlines%20over%20multiple%20data%20series%20within%20the%20same%20chart.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHowever%2C%20scatter%20plots%20do%20not%20allow%20x-axis%20labels%20to%20be%20populated%20with%20text.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESo%2C%20I%20have%20used%20a%20line%20chart%20(which%20allows%20text%20x-axis%20labels%2C%20e.g.%20January%2C%20February%2C%20etc)%2C%20that%20has%20two%20data%20series.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHow%20can%20I%20create%20a%20trendline%20in%20a%20line%20chart%20that%20combines%20the%20data%20from%20both%20series%2C%20the%20same%20way%20this%20is%20possible%20in%20a%20scatter%20plot%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-359275%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
sharrell
Occasional Visitor

I understand that scatter plots allow trendlines over multiple data series within the same chart.

 

However, scatter plots do not allow x-axis labels to be populated with text.

 

So, I have used a line chart (which allows text x-axis labels, e.g. January, February, etc), that has two data series.

 

How can I create a trendline in a line chart that combines the data from both series, the same way this is possible in a scatter plot?

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies