Download Article
Download Article
Once you have a set of data and a chart created, you can track the trends shown in the data with some lines called trend lines. This wikiHow will teach you how to add two trend lines in Excel on Windows and Mac.
Quick Steps to Add a Second Trendline to an Excel Chart
Select a chart in your spreadsheet. On Windows, click the + next to your chart and select Trendline , then the data to apply it to. Repeat this step to add a second trendline. On Mac, go to Chart Design > Add Chart Element to add a trendline. Do this twice to add two.
Steps
-
Open your project in Excel. You can either open Excel from your Start menu then click File > Open or you can right-click the project file in your file manager and click Open with > Excel .
-
Click to select a chart. You can only add trend lines to a chart, so if you don't have one create one .
- To create a chart, select your data set and click Insert > Recommended Charts or click a chart that you want. [1] X Trustworthy Source Microsoft Support Technical support and product information from Microsoft. Go to source
- In order to add two trend lines, you'll need to have data for more than one thing, like the performance of two or more sales people instead of a single store.
Advertisement -
Click + . It's at the top right corner of the chart and will open a drop-down menu.
-
Click Add Trendline . It's near the bottom of the menu.
-
Click a type of trendline that you want. The type of line, like Exponential , will change how the data is perceived, so you can click these to see a preview of the final result.
-
Select the data to apply this trendline to. If you're using the previous example of store employees instead of a single store, you can apply the exponential trendline to Jeff's data to show a severe increase in sales.
-
Click Ok . The trendline you picked and set will appear on your chart.
-
Click + . You'll only see this when the chart is selected, so if creating a trendline de-selected the chart, you need to click it again. It's at the top right corner of the chart and will open a drop-down menu.
-
Click Add Trendline . It's near the bottom of the menu.
-
Click a type of trendline that you want. The type of line, like Exponential , will change how the data is perceived, so you can click these to see a preview of the final result.
-
Select the data to apply this trendline to. If you're using the previous example of store employees instead of a single store, you can apply the linear projection trendline to John to show that his sales have been steadily decreasing.
-
Click Ok . The trendline you picked and set will appear on your chart and you'll have two trend lines visible. [2] X Research source
Advertisement
-
Open your project in Excel. You can either open Excel from your Applications folder then click File > Open or you can right-click the project file in Finder and click Open with > Excel .
-
Click to select a chart. You can only add trend lines to a chart, so if you don't have one create one .
- To create a chart, select your data set and click Insert > Recommended Charts or click a chart that you want.
- In order to add two trend lines, you'll need to have data for more than one thing, like the performance of two or more sales people instead of a single store.
-
Change the view to "Print Layout. " You can do this by going to View > Print Layout . [3] X Trustworthy Source Microsoft Support Technical support and product information from Microsoft. Go to source
-
Click Chart Design . It's at the top right corner of the chart and will open a drop-down menu. If you don't see this tab next to Review and View , make sure you have the chart selected.
-
Click Add Chart Element . You'll see this as the first option to the left of the "Chart Design" menu.
-
Click Trendline . It's near the bottom of the menu.
-
Click a type of trendline that you want. The type of line, like Exponential vs Moving Average , will change how the data is perceived, so you can click these to see a preview of the final result.
- Once you make a selection, the trend line will appear in your chart.
-
Click Chart Design . It's at the top right corner of the chart and will open a drop-down menu. If you don't see this tab next to Review and View , make sure you have the chart selected.
-
Click Add Chart Element . You'll see this as the first option to the left of the "Chart Design" menu.
-
Click Trendline . It's near the bottom of the menu.
-
Click a type of trendline that you want. The type of line, like Exponential vs Moving Average , will change how the data is perceived, so you can click these to see a preview of the final result.
Advertisement
Expert Q&A
Ask a Question
200 characters left
Include your email address to get a message when this question is answered.
Submit
Advertisement
Tips
Submit a Tip
All tip submissions are carefully reviewed before being published
Name
Please provide your name and last initial
Thanks for submitting a tip for review!
References
- ↑ https://support.microsoft.com/en-us/office/create-a-chart-from-start-to-finish-0baf399e-dd61-4e18-8a73-b3fd5d5680c2#OfficeVersion=Windows
- ↑ https://best-excel-tutorial.com/56-charts/437-chart-with-two-trendlines
- ↑ https://support.microsoft.com/en-us/office/add-a-trend-or-moving-average-line-to-a-chart-fa59f86c-5852-4b68-a6d4-901a745842ad#OfficeVersion=macOS
About This Article
Article Summary
X
1. Open your project in Excel.
2. Click to select a chart.
3. Click +
and Add Trendline
.
4. Click a type of trendline that you want.
5. Select the data to apply this trendline to then click OK
.
6. Click +
and Add Trendline
.
7. Click a type of trendline that you want.
8. Select the data to apply this trendline to then click OK
.
Did this summary help you?
Thanks to all authors for creating a page that has been read 28,352 times.
Advertisement
