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 Line button:

Choose Area and then modify this chart:

   3.   To add vertical lines, under Chart Tools, on the Design tab, in the Chart Layouts group, click the Add Chart Element icon and choose 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 Scatter button:

Choose Bubble with a 3-D effect and, 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.

See also this tip in French: Comment créer le graphique à bulles et à aires.