Excel Charts - Bubble Chart
A Bubble chart is like a Scatter chart with an additional third column to specify the size of the bubbles it shows to represent the data points in the data series.
Step 1 − Place the X-Values in a row or column and then place the corresponding Y-Values in the adjacent rows or columns on the worksheet.
Step 2 − Select the data.
Step 3 − On the INSERT tab, in the Charts group, click the Scatter (X, Y) chart or Bubble chart icon on the Ribbon.
You will see the different types of available Bubble charts.
A Bubble chart has the following sub-types −
- 3-D Bubble
Step 4 − Point your mouse on each of the icons. A preview of that chart type will be shown on the worksheet.
Step 5 − Double-click the chart type that suits your data.
In this chapter, you will understand when the Bubble Chart is useful.
Bubble and 3-D Bubble
Bubble and 3-D Bubble charts are useful to compare three sets of values and show relationships between the sets of values. The third value specifies the size of the bubble.
A Bubble chart shows the data in 2-D format. 3-D Bubble chart shows the data in 3-D format without using a depth axis