how do i display 2 trendlines on the same chart?

Copper 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

@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.