How to Create a Bubble Chart in Excel (Step-by-Step)
Bubble charts are a native Excel chart type available in all versions. They plot three variables simultaneously — X position, Y position, and bubble size — making them ideal for comparing items across two metrics while showing a third dimension through circle area. The most common stumbling block is adding text labels to each bubble, which requires a separate step after inserting the chart.
What is a bubble chart in Excel?
A bubble chart in Excel extends a scatter chart with a third variable: the size of each circle. Each data point has an X value, a Y value, and a size value — Excel plots the point at (X, Y) and draws a circle whose area is proportional to the size value. This lets you compare items across two axes while simultaneously communicating a third metric through visual area. Bubble charts are a native chart type available in all modern Excel versions under Insert → Scatter or Bubble.
6 steps to make a bubble chart in Excel
Prepare three-column data
Create three numeric columns: X axis values, Y axis values, and bubble size values. Each row is one data point (one bubble). Add a fourth column for category labels if you want to name each bubble — but keep this column separate from the three numeric ones. Do not include a header row in the selection if your headers are text.
Select the numeric columns only
Click and drag to select only the three numeric columns (X, Y, and size). Do not include the label column at this stage — Excel will misread text as a data series. Labels are added after the chart is created.
Insert the bubble chart
Go to Insert → Charts → Insert Scatter (X, Y) or Bubble Chart → Bubble. Excel creates the chart with one series. If you have multiple groups, each group should be in its own set of three columns and added as separate series.
Add category labels to each bubble
Right-click any bubble → Add Data Labels → right-click the labels that appear → Format Data Labels → check 'Value From Cells' → select your label column → click OK. Then uncheck 'X Value' and 'Y Value' so only the category names show. Drag labels away from overlapping bubbles as needed.
Adjust bubble scale
Right-click a bubble → Format Data Series → under 'Scale bubble size to represent:' reduce to 50–70%. The default 100% typically causes large bubbles to overlap. Adjust until bubbles are readable without covering neighboring points.
Add axis titles and annotations
Click the chart → Chart Elements (+) → Axis Titles → add titles for both axes. Describe what X, Y, and bubble size represent — a bubble chart without axis labels is uninterpretable. Consider adding a size legend (a reference bubble in a corner with a known size value).
When to use a bubble chart in Excel
Comparing companies or products across three metrics
Classic use: plot companies with revenue on X, growth rate on Y, and market cap as bubble size. Instantly shows which companies are large, fast-growing, and profitable simultaneously.
Country or regional comparisons
GDP on X, life expectancy on Y, population as bubble size. Made famous by Hans Rosling's Gapminder charts — Excel's native bubble chart recreates this format exactly.
Product portfolio analysis
Plot SKUs by price on X, sales volume on Y, and margin as bubble size. Identifies high-margin/high-volume products vs expensive/low-volume ones at a glance.
Risk matrix with magnitude
Plot risks by likelihood on X, impact on Y, and cost of mitigation as bubble size. Prioritizes which risks to address first based on three dimensions simultaneously.
Components of a bubble chart in Excel
X axis
The horizontal position of each bubble. Represents one numeric variable (e.g., revenue, price, likelihood).
Y axis
The vertical position of each bubble. Represents a second numeric variable (e.g., growth rate, rating, impact).
Bubble size
The area of each circle. Represents a third numeric variable (e.g., market cap, population, volume). Excel scales bubble sizes proportionally to the values — the largest value gets the largest bubble.
Data labels
Text labels identifying each bubble. Not included by default — must be added via Format Data Labels → Value From Cells after inserting the chart.
Series
Each color represents one group or category. Multiple series require separate sets of X/Y/size columns, each added as a separate series in Select Data.
Frequently Asked Questions
Related