Bubble and Area chart

Excel 365 2013 2010 2007
In this tip, we will show how to different charts could be combined in the one chart. For example, we will combine a Bubble chart with an Area chart:
Bubble and area charts in Excel 2016

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:

Charts group in Excel 2016

Choose Area and then modify this chart:

An area chart in Excel 2016

   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:

Drop Lines in Excel 2016

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:

Scatter Charts group in Excel 2016

Choose Bubble with a 3-D effect and, if it is necessary, add another data series:

Bubble chart in Excel 2016

   3.   Remove axes, legend, and title.

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

Format Chart Area in popup Excel 2016

   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.
Format Chart Area in Excel 2016

   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.

If you have any questions or suggestions, please feel free to ask OfficeToolTips team.