Press the Next button at the bottom of the Chart Wizard window. There is nothing to change in the window. Step 9 - The next window is the Source Data window (Step 2 of 4 in the Chart Wizard).
Step 8 - Click the Next button at the bottom of the Chart Wizard window. As long as you leave the mouse button depressed, you will see the sample graph produced from the data used. To see what the chart will look like, click on the button that says Press and Hold to View Sample. Step 7 - Select XY (Scatter) as the chart type. Step 6 - Click on the Chart Wizard button or choose Chart from the Insert menu. All data between the clicks is highlighted. An easy way to highlight data is to click one time on the top left number, hold down the Shift key, and with the Shift key depressed, click on the bottom right number. Step 5 - Highlight the data to be turned into a chart. When the cursor turns to a black plus, depress your left mouse button and drag down even with the last value on the left to fill the equation down. Put your cursor on top of the black block on the bottom right corner of the cell. To put the same equation in each of the other cells, click on the cell where the equation is located. Step 4 - Press Enter after entering the equation. Step 3 - In cell B2 enter the equation Excel will use to calculate Y. Step 2 - Enter seven values for x in column A. Step 1 - Open excel, type x in cell A1 and type y in cell B1. Excel will be used to create the values from the equation, will then be used to display a scatter plot of the data, and then will be used to find the best fit for the given data. The equation which will be used in this example is y=3x-2. This shows a clear pattern or trend.This tutorial will use a linear equation to create a table of values for Y when given a set of x values. Moving Average : This trendline is useful in forecasting through moving average.Like a power trendline, you can’t use an exponential trendline with negative or zero values. Exponential: An exponential trendline is also a curve line that’s useful for data sets with values that rise or fall at increasingly higher rates.This trendline is only possible for positive values. Power: A power trendline is another curve line used with data sets comparing values that increase at a specific rate.The fluctuations are seen as a hill or valley in the trendline. Polynomial: A polynomial trendline is also a curved line used to visualize data fluctuations.It’s a best-fit curved line and uses a negative and/or positive values. Logarithmic: This one is commonly used when there are quick changes in the data which levels out.Results are easy to interpret as they’re either increasing or decreasing at a steady rate. Linear: From the name itself, this is a best-fit straight line usually used with simple linear data sets.In Excel, most charts allow trendlines except for pie, radar, 3-D, stacked charts and other similar ones.Īs stated earlier, there are 6 different types of trendlines: A trendline, also called “a line of best fit”, is an analytical tool that is used to visualize and represent the behavior of a data set to see if there’s a pattern.