![]() In the Format Data Series pane, please (1) click the Fill & Line icon, (2) expand the Line section and (3) Select Round Dot from the Dash type drop-down list. Right-click the forecast line, and click Format Data Series from the context menu. ![]() Now the forecast line is added to the line chart. Please (1) type Forecast in the Series name box, (2) specify the Forecast column excluding the column header as Series values, and then (3) click the OK buttons successively to close the two dialog boxes. Now the Edit Series dialog box comes out. In the Select Data Source dialog box, please click the Add button in the Legend Entries (Series) section. Right-click the line chart, and click Select Data in the context menu. Note: Please remember to add the sales amount of Jun in the Forecast column too.Ģ. Beside the source data, add a Forecast column, and list the forecast sales amount as below screenshot shown. To add a dotted forecast line in an existing line chart in Excel, please do as follows:ġ.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |