Bubble and Area chart

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 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 Word 2016

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

An area chart in Word 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 Word 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 second chart, follow these steps:

    1.    Select the data range.

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

Charts group in Word 2016

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

Bubble chart in Word 2016

    3.    Remove axises, legend and title.

    4.    Open the Format Chart Area on the Format task pane:

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

    5.    Open the Format Plot Area on the Format task pane:

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

Thank you for visiting OfficeToolTips

We are glad to help you in your work. However, you are using ad blocker and our efforts will not be rewarded.

Please consider disabling ad blocker before continuing the reading.