![]() 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.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |