How to Analyze Trends in Excel

In this article, TipsMake will guide you how to create a data chart project in Microsoft Excel. You can do it on Windows and Mac.

On Windows

How to Analyze Trends in Excel Picture 1

Open the Excel document. Double click on the Excel document that stores the data.

If you haven't entered the data you want to analyze into the table, open Excel and click Blank workbook to create a new document. You can import data and draw charts based on it.

How to Analyze Trends in Excel Picture 2

Select chart. Click on the chart type you want to use to create a trendline.

If you haven't already drawn a graph from the data, do so before continuing.

How to Analyze Trends in Excel Picture 3

Click on ＋ . This is the green button located in the upper right corner of the chart. The menu will appear.

How to Analyze Trends in Excel Picture 4

Click the arrow to the right of the "Trendline" dialog box. Many times you have to drag your mouse to the far right corner of the "Trendline" dialog box to see the arrow appear. Click to return to the 2nd menu.

How to Analyze Trends in Excel Picture 5

Select trendline. Depending on your needs, you can choose one of the following options:

Linear _

Exponential _

Linear Forecast

Two Period Moving Average

You can click More Options. to open the advanced options panel after selecting data to analyze.

How to Analyze Trends in Excel Picture 6

Select data to analyze. Click on the data series name (e.g. Series 1 ) in the window. If you have named the data, you can click on the data name.

How to Analyze Trends in Excel Picture 7

Click OK . This button is at the bottom of the pop-up window. This is the operation of adding a trend line to the chart.

If you click More Options. , you can name the trendline or change its direction to the right side of the window.

How to Analyze Trends in Excel Picture 8

Save document. Press Ctrl+ Sto save changes. If you haven't saved the document before, you'll be asked to choose a save location and file name.

On Mac

How to Analyze Trends in Excel Picture 9

Open the Excel document. Double click on the data store document.

If you haven't entered the document you want to analyze into the table, open Excel to create a new document. You can import a document and draw a chart based on it.

How to Analyze Trends in Excel Picture 10

Select data in the chart. Click on the data series you want to analyze.

If you haven't already drawn a graph based on your data, draw one before continuing.

How to Analyze Trends in Excel Picture 11

Click the Chart Design tab. This tab is at the top of the Excel window.

How to Analyze Trends in Excel Picture 12

Click Add Chart Element . This option is on the far left side of the Chart Design toolbar . Click here to view the menu.

How to Analyze Trends in Excel Picture 13

Select Trendline . The button is at the bottom of the menu. You will see a new window appear.

How to Analyze Trends in Excel Picture 14

Select trendline options. Depending on your needs, you can choose one of the following types:

Linear

Exponential

Linear Forecast

Moving Average

You can click More Trendline Options to open the advanced options window (e.g. trendline name).

How to Analyze Trends in Excel Picture 15

Save changes. Press the ⌘ Command+ key Save, or click File and then select Save . If you haven't saved the document before, you'll be asked to choose a location and file name.