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 2007

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 2007

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

An area chart in Word 2007

    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 2007

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 2007

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

Bubble chart in Word 2007

    3.    Remove axises.

    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 2007
  • 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.

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.