Formatting the bubbles

To format the bubbles in a bubble chart, follow the steps below:

1. Right-click any bubble in the bubble chart, and then select Format Bubble to display the Format Bubble dialog.
2. In the General tab, specify whether or not to apply a 3D visual effect to the bubbles, and you can use the option Cut Bubble Based on XY Area to control whether or not to cut the bubbles when they are beyond the area formatted by the X axis and Y axis.
3. In the Fill tab, click the color image button and select a color swatch to fill all bubbles if the chart has no series field or the selected bubbles in the same data series, and specify the transparency of the color schema (you can also directly type the hexadecimal value of the desired color in the text box). If the color swatches cannot meet your requirement, click More Colors on the color palette to open the Pick a Color dialog, with which you can set a full range of color, or click More Fill Effects to specify the fill effect in the Fill Effects dialog. You can also click the Color List button to specify the color pattern for bubbles in the same data series respectively in the Color List dialog.
4. In the Border tab, set the border mode for the bubbles, including the border style, color, transparency, line style, thickness, end caps style, and line joint mode. You can also specify whether the border is to be outlined, and whether or not to automatically resize the border dashes if the border is drawn with dashes.
5. In the Data Label tab, set the font formats and effects of the data labels.
6. When done, click OK to apply the changes.

See also Format Bubble dialog for detailed explanation about options in the dialog.