Line chart actual with forecast

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.
Chart type
Download 200+ Excel Shortcuts
Get over 200 Excel shortcuts for Windows and Mac in one handy PDF.