Create a bubble plot with groups on separate panels

If you want your bubble plot to include groups, you can display them on separate panels of the same graph.

For example, this bubble plot shows the Combined MPG vs the Total Volume for automobiles at a dealership, paneled by safety rating. The bubble size represents the retail price.

To create a bubble plot with groups in panels, you must use a worksheet that contains three columns of measurement data and at least one column of categorical data for grouping. All columns must have the same number of rows.

Example worksheet

C1 C2 C3 C4
Combined MPG Total Volume Retail ($1000) Safety (0-5)
19.25 187.0 31.3 4
25.50 132.3 31.0 4
39.55 132.3 35.6 5
... ... ... ...
  1. Choose Graph > Bubble Plot.
  2. Choose With Groups, then click OK.
  3. Under Y variable, enter a column of Y-values. In the example, Total Volume is the Y variable.
  4. Under X variable, enter a column of X-values. In the example, Combined MPG is the X variable.
  5. Under Bubble size variable, enter a column of values to determine the bubble size. In the example, Retail ($1000) is the bubble size variable.
  6. Under Panel variables (optional), enter one or more columns of categorical data. In the example, Safety (0-5) is the panel variable.
  7. Click OK.
By using this site you agree to the use of cookies for analytics and personalized content.  Read our policy