Help users increase productivity by automatically signing up for TechRepublic’s free Microsoft Office Suite newsletter, featuring Word, Excel, and Access tips, delivered each Wednesday. Miss a tip?Ĭheck out the Microsoft Excel archive, and catch up on our most recent Excel tips. Show estimated monthly sales figures for the rest of the year. The Forecast section, click on the up arrow in the Forecast box until the On your chart, and then click on the data series.
You can use trendlines to have Excel predict the answers based on yourĪ bar chart of the data you’ve tracked so far. Additionally, select Trendline from the Chart Element That will instantly add a linear Trendline to the plot. Click on the ‘ + ’ sign or the Chart Element. To do so, we will follow these steps: To begin with, we need to select the chart. The past six months (January through June), and you want to know what the overall sales will likely be for the second half of the year. First, we will need a Trendline on our plot to add a Trendline equation to it.
Let’s say you are keeping track of monthly sales figures for With trendlines, Excel can project future figures based on previous history. Trying to predict the future based on past experiences, but you're lacking the right formula? If you've forgotten high school algebra, fear not.
Forecast the future with Excel trendlines