Bubble charts are typically used to show three dimensions of data in a two dimensional chart. This type of chart often lends itself to the display of financial data because specific values can be visually represented in your chart by different bubble sizes. It is similar to scatter chart allowing you to plot data as a collection of bubbles. Bubble charts plot three values:
Value set on the x-axis
Value set on the y-axis
Value that defines the size or width dimension of a bubble in proportion to the amount of data
Multiple data values can be plotted in the bubble chart.
Bubbles with zero size can rendered using some small bubble size to prevent them from disappearing. Also there is an option can be provided to hide zero-size values if necessary.
Bubbles with negative values can also be displayed. These type of values are derived from their real absolute value, and the real negative value is depicted in the data label (although based on the positive value). You can optionally select not to show negative values.
Bubble charts have the following limitations:
Data functions are not available (this type of chart relies on non-aggregated data)
Sort is not available
Pivot To Chart is not available.
Drilling cannot be performed
Focus cannot be used
Hide hides the whole data series in a bubble chart; an individual item cannot be hidden.
To create a bubble chart: