Bubble and Area chart

To create the first chart, follow these steps:

   1.   Select the data range.

   2.   On the Insert tab, in the Charts group, choose the Insert Line or Area Chart button:

Choose the Area chart and then modify this chart:

   3.   To add vertical lines, on the Chart Design tab, in the Chart Layouts group, click the Add Chart Element dropdown list:

In the Add Chart Element dropdown list, select the Lines list and then Drop Lines:

You can customize drop lines: right-click in any one of these lines and choose Format Drop Lines... in the popup menu.

To create the second chart, follow these steps:

   1.   Select the data range.

   2.   On the Insert tab, in the Charts group, choose the Insert Scatter (X, Y) or Bubble Chart button:

Choose Bubble or 3-D Bubble:

If it is necessary, add another data series:

   3.   Remove axes, legend, and title.

   4.   Right-click in the chart area and select Format Chart Area... in the popup menu:

   5.   On the Format Chart Area pane:

• In the Fill section, select the No fill checkbox.
• In the Border section, select the No line checkbox.

   6.   Right-click in the chart area and select Format Plot Area... in the popup menu.

   7.   On the Format Plot Area pane:

• In the Fill section, select the No fill checkbox.
• In the Border section, select the No line checkbox.

The last and the most hard step: move the second chart.