In this Excel tutorial you will learn how to insert a chart with your data and goal which was expected. This kind of chart is the best for sales/production reports or business plan for the company you want to establish.

Select your data and go to insert column chart and select clustered column chart. B column is goal line and C column is your data.

Now right click the blue bars, which are expected sales and select change series data chart type.

A dialog box will appear.

Change expected sales to chart type line with markers. Now click ok.

Final result will be like this: