Bubble and Area chart

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

To create the first chart, follow these steps:

   1.   Select the data range.

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

Charts group in Word 2010

Choose Area in the 2-D Area group and then modify this chart:

An area chart in Word 2010

   3.   To add vertical lines, under Chart Tools, on the Layout tab, in the Analysis group, choose the Lines button and then choose Drop Lines:

Drop Lines in Word 2010

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

To create second chart, follow these steps:

   1.   Select the data range.

   2.   On the Insert tab, in the Charts group, choose the Other Charts button:

Charts group in Word 2010

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

Bubble chart in Word 2010

   3.   Remove axes.

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

  • On the Fill tab, choose No fill:
    Format chart area in Word 2010
  • On the Border Color tab, choose No line.

   5.   Right-click in the plot area and select Format Plot Area... in the popup menu. In the Format Plot Area dialog box, on the Fill tab, choose No fill.

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.