Feb 17 2020 08:25 PM
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?
Assistance much appreciated,
Benjamin
Feb 17 2020 09:47 PM
@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.