Bubble chart

A bubble chart is a variation of a scatter chart in which the data points are replaced with bubbles, and an additional dimension of the data is represented in the size of the bubbles. Like a scatter chart, a bubble chart does not use a category axis, because both horizontal and vertical axes are value axes. In addition to the X and Y values, a bubble chart plots Z (size) values. Categories form bubbles, where the number of bubbles is equal to the number of categories.

You can change the chart color in the Properties page of the wizard.

After the chart is created, click Edit to select this additional option:

Swap Chart Axes: To quickly swap the variables on the horizontal and vertical axes.