Often you may want to add multiple trendlines to a chart in Excel to summarize the trends of multiple series.
For example, you may want to create the following plot with multiple trendlines that summarizes the trend of two different product sales over time:
The following step-by-step example shows how to create this exact plot with multiple trendlines.
Step 1: Create the Data
First, let’s create the following dataset that shows the total sales of two different products during 10 consecutive years:
Step 2: Insert the Scatter Plot
Next, highlight the cell range A1:C11, then click the Insert tab along the top ribbon, then click the Scatter icon within the Charts group:
The following scatter plot will automatically appear:
The blue dots represent the sales each year for Product A and the orange dots represent the sales for Product B each year.
Step 3: Add the Trendlines
Next, click on any of the blue dots in the plot.
Then click the tiny green plus sign that appears in the top right corner of the chart, then click the dropdown arrow next to Trendline, then click More Options:
In the Format Trendline panel that appears, click the button next to Linear, then check the box next to Display Equation on chart:
Repeat this same process for the orange dots.
Two trendlines with their equations will now be displayed on the chart:
Step 4: Customize the Chart Appearance
Lastly, click on the individual labels in the legend called Linear (Product A) and Linear (Product B) and delete them.
Then add a custom chart title, add custom axis labels, and make the font color of the trendline equations bold to make them easier to read.
The final chart will look like this:
The following tutorials explain how to perform other common tasks in Excel: