Add Change Or Remove Trendline In Chart. You can expand the options in the left pane or in the right panel. Repeat the above steps for the other data series.
However I wanto to include both Add and Remove trendline depending on the condition If selected remove and opposite. This will open the Trendline Options tab of the pane where you can choose the desired line type. Click the trendline you want to delete and then press Delete.
In the popup menu select Add Trendline.
Next to Apply to choose the data series you want to add the trendline to. Click the checkbox Display Equation on chart. To put a trendline on a chart that has two or more data series heres what you do. Alternatively to format trendlines in Excel charts you can also right-click the trendline to format within the actual chart.
