Situatie
When you want to display three data series on a type of scatter plot, then a bubble chart is the ideal choice. We’ll show you how to organize your data and create a bubble chart in Microsoft Excel.
Solutie
- Prepare the Bubble Chart Data
Because Excel plots the data that you provide on the chart for you, you’ll want to be sure it’s organized correctly. Here are the basics to keep in mind:
- A bubble chart does not use a category axis, but values instead.
- A bubble chart uses values for x, y, and z whereas a scatter plot uses only x and y.
- Arrange your data so that the x values are in the first row or column with the corresponding y values next and z at the end. Remember that the z values determine the sizes of the bubbles.
- Be sure that you have at least four rows or columns of data.
- Do not include row or column headers in your data selection for the chart. Otherwise, it may not display the data correctly.
We’ll use the data below as an example for the bubble chart. You can see the x values are in column A, y values are in column B, and z values are in column C.
Create the Bubble Chart
- Select the data set for the chart by dragging your cursor through it. Then, go to the Insert tab and Charts section of the ribbon.
- Click the Insert Scatter or Bubble Chart drop-down arrow and pick one of the Bubble chart styles at the bottom of the list.
Your chart displays in your sheet immediately. You can see our Quantity values (x) along the bottom, Cost values (y) along the left side, and Sales values (z) as the sizes of the bubbles.
From here, you can drag to move or resize the chart, or customize it to include a trendline, legend, data labels, and more.
Customize the Bubble Chart
You have a few different ways to customize the bubble chart in Excel. Select the chart open one or more of the following views.
Chart Design Tab
Open the Chart Design tab to apply a different layout, pick a new style, switch the columns and rows, or add a chart element.
Format Tab
Open the Format tab to use a fill color, outline, effect, WordArt, or alt text.
- Format Chart Sidebar
Right-click the chart and choose “Format Chart Area.” You can then do some of the same things as on the Format tab. You can add a fill or border color, apply a shadow or glow, and change the size or properties.
