To do this there are a few steps to follow:
1. Enter the Line Chart for the 12 months of sales;
2. Enter the values you want to highlight on a separate column next to the sales;
3. Click on the Line Chart and drag the blue line that is in the sales column to include the new column (in point 2);
4. Click on the chart and go to Chart Tools > Layout > Select Series 2;
5. Go to Chart Tools > Design > Change Chart Type > Area Chart;
6. Right click in the Area Chart and format it to your liking with a light color.
download workbookArea-Chart.xlsx
John Michaloudis is a former accountant and finance analyst at General Electric, a Microsoft MVP since 2020, an Amazon #1 bestselling author of 4 Microsoft Excel books and teacher of Microsoft Excel & Office over at his flagship MyExcelOnline Academy Online Course.