You could add a line yourself using the Shapes item on the Illustrations panel.

At Year 2 (2008) we made just over 14000, and so on.Īll these dots seem to form a loose line going up from the left. At Year 1 (2007) we made just under 16000. The first dot, the one on the far left, tells us that we made just over 12000 at Year 0, (Year 0 is 2006). The figures on the Y Axis are our income values.

The figures along the bottom, the X Axis, are our years since 2006. Switch to the All Charts tab, then select X Y Scatter).Ī new chart will then appear on your spreadsheet. (If you can't see the icon above, click on Recommended Charts. Select the first item to get a chart with just dots: From the Charts panel, locate and click on the Scatter charter icon. We're now ready to insert an X, Y Scatter chart.įrom the top of Excel, click on the Insert ribbon. Enter some income values, then, into cells C2 to C9. We'll then use this hard data to predict future values. This is income that has actually been earned, rather than income that might be earned in the future. We now need some income values for the years 2006 to 2013. In Cells B2 to B15 enter the values 0 to 13: These values will be used in a later formula. Your spreadsheet will then look like this:Įnter the years 2006 to 2019 into cells A2 to A15:Īs an X axis for our chart, we can have the years since 2006. Type the following headings into cells A1 to C1:įormat the cells, if you prefer.

If you're a bit confused, don't worry: it will all become clear as we go along. We'll take a look at future income predictions based on what was earned in previous years.

We'll use an X, Y Scatter chart for this. What we'll do in this section is set up something called a Trendline. Predicting future values with Excel ChartsĮxcel can help you make predictions about future values, or help you spot a linear trend.

Microsoft office excel 2019 trendline