Forum Discussion
null null
Feb 17, 2020Copper Contributor
how do i display 2 trendlines on the same chart?
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 tren...
Riny_van_Eekelen
Feb 17, 2020Platinum Contributor
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.