11/10/2023 0 Comments Openoffice calc graph forecast![]() ![]() As the Sep data is actual, we need to configure this marker to display as the Actual series.Ĭlick this marker twice to only select it, and in the Format Data Point pane, separately select the same Fill color and the Border color as the color of the Actual series, and then choose Solid from the Dash type drop down list.Īfter that, you can see the marker of Sep is changed as follows.ħ. In the opening Format Data Series pane, please configure as follows.ĥ.7) Go to the Line tab, and then select Square Dot from the Dash Type drop down list.Ħ. ![]() Right click the blue line (the Actual series) and then select Format Data Series from the right-clicking menu.Ĥ. Select the whole table data, click Insert > Insert Line or Area Chart > Line with Markers.ģ. Note: Next to the last actual data cell, enter the same data.Ģ. Firstly you need to create a column containing the prediction data of Oct, Nov and Dec as the below screenshot shown. Supposing you have a sales table containing the actual sales data from Jan to Sep as the below screenshot shown, and you want to predict the sales trends of Oct, Nov and Dec within a chart, you can do as follows to get it down.ġ. Apart from creating a forecast worksheet, this article is going to show you how to create a forecast chart directly based on data in a worksheet.Ĭreate a forecast chart based on a threshold valueĮasily create a forecast chart with an amazing tool By default, Excel provides a build-in feature to help creating a new worksheet to predict data trends. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |