To create charts like these (sales data for the week for 3 months), do the following:

Step I: Create a chart with a scroll bar (see Creating a Scrolling Chart).

Step II: Create a chart with a total data:

1. Select the data (in this example, A4:B95).
2. On the Insert ribbon, in the Charts group, choose Line:
   
   
   Choose the Line chart type, delete the legend.
3. Move the chart so that it was placed under the chart with a scroll bar.

Step III: Add an additional data:

1. Add the next column to your data (in this example, C4:C95) and enter the following formula in the first cell:
   
   =IF(AND(ROW(A4)>=$E$1+3,ROW(A4)-$E$1<7+3,B4,0).
2. Copy this formula down to the other cells.

Step IV: Add a shaded box on the chart with a total data.

1. Select the range of the additional data (in this example, C4:C95), press Ctrl+C to copy the range. Select the bottom chart and press Ctrl+V to paste a new series to the chart.
2. Select the second data series and do one of the following:
   • Under Chart Tools, on the Design tab, in the Type group, choose Change Chart Type:
     
   • Right-click and choose Change Series Chart Types... in the popup menu:
     
3. In the Change Chart Type dialog box, choose the Area group and then choose the Area chart type:
   
4. Click the area chart to select the second series. Under Chart Tools, on the Format tab, in the Shape Styles group, choose Shape Fill and select a color to make the shaded box: