how do i display 2 trendlines on the same chart?

%3CLINGO-SUB%20id%3D%22lingo-sub-1178624%22%20slang%3D%22en-US%22%3Ehow%20do%20i%20display%202%20trendlines%20on%20the%20same%20chart%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1178624%22%20slang%3D%22en-US%22%3E%3CP%3Ehello%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECurrently%20have%202%20sets%20of%20data%20points%20(i.e.%20series%20A%20%26amp%3B%20series%20B).%3C%2FP%3E%3CP%3EApparently%2C%20only%20series%20B%20data%20points%20(orange%20circles)%20can%20be%20displayed%20on%20the%20chart%2C%20together%20with%20the%20corresponding%20trendline.%3C%2FP%3E%3CP%3EIs%20there%20a%20way%20to%20display%20*both*%20series%20A%20%26amp%3B%20series%20B%20data%20points%2C%20as%20well%20as%20the%202%20corresponding%20trendlines%20on%20the%20same%20chart%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-left%22%20image-alt%3D%22graph.PNG%22%20style%3D%22width%3A%20994px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F171578iDD71F080F7EC3996%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22graph.PNG%22%20alt%3D%22graph.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAssistance%20much%20appreciated%2C%3C%2FP%3E%3CP%3EBenjamin%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1178624%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ECharting%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1178658%22%20slang%3D%22en-US%22%3ERe%3A%20how%20do%20i%20display%202%20trendlines%20on%20the%20same%20chart%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1178658%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F85050%22%20target%3D%22_blank%22%3E%40null%20null%3C%2FA%3E%26nbsp%3BI%20guess%20you%20want%20to%20remove%20Series3%20from%20you%20data%20and%20set%20Series%20A%20so%20that%20the%20Y-values%20point%20to%20column%20C.%20You%20currently%20have%20them%20pointing%20at%20column%20D%20which%20has%20no%20values.%20I%20suspect%20that%20the%20incorrect%20reference%20occurred%20because%20your%20data%20sits%20in%20merged%20cells.%20I'd%20recommend%20to%20reformat%20your%20columns%20that%20contain%20the%20data.%20Have%20attached%20a%20file%20with%20the%20graph%20you%20probably%20want.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

hello,

 

Currently have 2 sets of data points (i.e. series A & series B).

Apparently, only series B data points (orange circles) can be displayed on the chart, together with the corresponding trendline.

Is there a way to display *both* series A & series B data points, as well as the 2 corresponding trendlines on the same chart?

 

graph.PNG

 

 

 

 

 

 

 

 

 

Assistance much appreciated,

Benjamin

1 Reply
Highlighted

@null null I guess you want to remove Series3 from you data and set Series A so that the Y-values point to column C. You currently have them pointing at column D which has no values. I suspect that the incorrect reference occurred because your data sits in merged cells. I'd recommend to reformat your columns that contain the data. Have attached a file with the graph you probably want.