Bubble and Area chart

Unfortunately, you can't choose the Bubble chart as an alternative chart type for line, area, etc. charts in the Change Chart Type dialog box (see Using two axes in the one chart), but there is another way. You can place the chart on top of another.
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. On the Format Drop Lines pane, on the Fill & Line tab, in the Line section, select the Solid line radio button and choose the color and width in the appropriate fields:

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 challenging step: place the second chart over the first chart.
See also this tip in French: Comment créer le graphique à bulles et à aires.