This chart shows actuals so far in a solid line with forecast numbers in a dashed line. The chart type is set to line chart, and actual and forecast values are plotted as two data series. The data used for the chart is set up as shown below:
How to make this chart
- Select the data and insert a line chart:
- Choose the first option, a basic line chart:
- Chart as inserted:
- Select Forecast data series and apply dashed line:
- After setting dashed line on Forecast data series:
From this point, you can set the chart title and move the legend.