Excel does not combine its standard Filled Map chart with bubble-size markers in one chart type. In Excel for Microsoft 365 on Windows, you can create a geographic bubble map with 3D Maps: select a location field, choose the Bubble visualization, and use a numeric field to size the markers.
What a map bubble chart means in Excel
A map bubble chart places circles on a map to show values at particular places. A bubble can mark a city, store, state, or other location, while its size represents a measure such as sales, population, or the number of service requests. The geographic position answers “where?” and the bubble size helps answer “how much?”
Excel’s ordinary chart types separate these jobs. A Bubble chart compares three numeric variables on an X-Y plot, with a third value controlling each bubble’s size; it does not automatically show a geographic map. A Filled Map shades geographic regions according to values, but it does not provide a separate, size-varying circle for every location. Excel’s 3D Maps feature is the built-in option for placing bubbles on a geographic view.
Choose the right Excel tool
Before arranging your data, decide which visual form suits the question. Use 3D Maps when you need actual map locations marked with bubbles. Use a Filled Map when the comparison is between areas and color intensity is enough—for example, sales by state. Use a standard Bubble chart when the relationship between numeric measures matters more than geography, such as price versus sales volume.
There is an important distinction between a map with bubbles and a bubble chart that happens to contain location names. Typing city names into a regular Bubble chart will not geocode them or place points on a map. Similarly, adding a size column to data for a Filled Map does not turn the shaded regions into differently sized circles. The chart type must support the visual encoding you need.
- Geographic bubbles: 3D Maps, with a location and a numeric size field.
- Region shading: a Filled Map, with values associated with recognized geographic areas.
- Three numeric measures: a regular Bubble chart, where X and Y are coordinates in the data and a third measure controls size.
Prepare location and value data
Organize the source as a simple table, with one row for each location or location-and-period combination. Use clear column headings such as City, State, Country, Revenue, and Year. A sample might have Boston, Massachusetts, United States, 125000, and 2025 on one row, followed by other cities. Keep the value used for bubble size numeric; values stored as text may not behave as intended.
Give Excel enough information to distinguish places with the same name. A City column containing Springfield alone can be ambiguous, while City, State, and Country together are much clearer. For postal codes, include the country or region and preserve leading zeroes by storing codes as text. Do not combine multiple unrelated locations in one cell if you want Excel to recognize each one separately.
For a useful map, also consider the structure of the metric. If the bubble is meant to represent total sales, each point should have the intended total for that location. If the source has many transaction rows per city, summarize the data by city before mapping, or confirm how 3D Maps aggregates repeated locations. Otherwise, a location may appear more than once or its value may be unintentionally summed.
- Use one header row and avoid blank rows or merged cells in the data range.
- Include a consistent unit, such as dollars, units sold, or incidents, in the column name or chart legend.
- Check that locations are spelled consistently and that state and country fields are in separate columns where practical.
- If you have dates, use actual Excel date values rather than text that only looks like a date.
Create a bubble map with 3D Maps
These directions are for the desktop version of Excel for Microsoft 365 on Windows. Start with the prepared location table in the workbook. If the data is in a normal range, convert it to an Excel table with Insert > Table; a table makes the data easier to manage when rows are added later.
- Click a cell in the source table. On the ribbon, choose Insert > 3D Map > Open 3D Maps. If Excel asks, create a new tour. A tour is a saved set of map scenes in the workbook.
- In the 3D Maps window, use the Layer pane to assign the geographic fields. Drag or select fields such as City, State, and Country in the Location area. Check the map preview to see whether Excel has placed the points where you expect.
- Set the layer’s visualization to Bubble. Add the numeric measure, such as Revenue, to the Height field. In a bubble layer, that measure controls the marker size; it is not a height above the ground in the way a column layer depicts height.
- Optionally put a category such as Product or Region in the Category area to distinguish groups by color. Use a date field in the Time area only when you want to show changes over time.
- Inspect the map, adjust the view, and use the available layer formatting options to improve contrast and legibility. Close the 3D Maps window when finished; the tour is stored with the workbook.
3D Maps may take a moment to interpret the first location field. If the initial result is vague or misplaced, add a more specific geographic field rather than accepting an uncertain match. For example, a city paired with its state and country usually gives Excel more context than a city name on its own.
Size, color, and read the bubbles well
Choose a size measure that has a meaningful relationship to the locations. Revenue, population, and order count are common examples. A legend and clear title should state what the bubbles represent and, where useful, the unit. Without that explanation, a viewer may mistake a large circle for a more important category rather than a larger numeric value.
Bubble maps become difficult to read when nearby points overlap. This is common in dense urban areas: the largest marker can cover smaller ones, and several circles at one location may conceal each other. Try narrowing the mapped area, filtering to a relevant group, or summarizing locations at a larger geographic level. If the goal is to compare individual cities, avoid aggregating them into states unless that matches the question.
Use category colors sparingly. A small number of distinct groups can help readers compare regions or product lines, but many similar colors create a hard-to-decode legend. Color should represent a separate category, not repeat the same magnitude already shown by size unless there is a clear reason. Check the map at the size at which it will actually be viewed; circles that look distinct on a large monitor may merge in a presentation or printed page.
Example: comparing sales across cities
Suppose a sales table has one row per city and columns for City, State, Country, and Annual Sales. In 3D Maps, use the three geographic fields to locate each point, select Bubble for the layer, and assign Annual Sales as the size measure. A larger bubble then identifies a city with a larger sales figure. If a second table includes sales by year, add a date or year field for a time-based view, or filter the data to compare one year at a time.
Before interpreting the result, check whether the figures are comparable. A city with more stores may naturally have higher total sales than a city with one store. If the question is about sales performance rather than total business size, a per-store measure or sales per resident might be more informative, provided the denominator is reliable. The chart does not decide what a fair comparison is; it only displays the values supplied.
Common problems and their fixes
- 3D Maps is missing: Confirm that you are using the Windows desktop version of Excel and that the command is available in your installation. 3D Maps is not available in Excel for the web or Excel for Mac. In managed work environments, ribbon commands can also be restricted by an administrator.
- Locations appear in the wrong place: Add state, province, country, or another relevant location field to disambiguate the name. Review unusual spellings and postal-code formatting, then check the map again.
- Bubbles all appear similar: Verify that the size field contains numeric values and that it is assigned to Height for the Bubble layer. Check for text-formatted numbers, blanks, or values that are nearly identical.
- Several bubbles overlap: Filter the data, zoom in, or summarize the points at a suitable level. A map cannot make tightly packed locations individually visible without changing the view or reducing the number of marks.
- The total looks unexpectedly large: Check for multiple source rows per location and determine whether the layer aggregates them. Summarize the source to the intended unit before mapping if the default grouping does not match your analysis.
Limits and alternatives
3D Maps is designed for interactive geographic exploration, including map scenes and, when configured, time-based changes. It is not the same as an ordinary embedded chart with a simple set of editable data labels, and it may not be the best choice when you need a static, tightly controlled graphic for a report. Excel for Mac and Excel for the web do not offer the 3D Maps feature, so a workbook relying on it should be prepared and viewed in supported Windows desktop Excel for that experience.
If you need a static presentation, one workaround is to create a geographic visualization in a mapping or business-intelligence tool that supports proportional symbols, then insert an exported image into Excel. That image will not update as an Excel chart when the source data changes. Another option is a regular XY Bubble chart using longitude as X and latitude as Y, but that plot has no geographic background by itself; adding a map image behind it requires careful alignment and is less robust than a purpose-built map.
For a state- or country-level comparison, Excel’s Filled Map may be simpler. Select the geographic data and use Insert > Maps > Filled Map, where the command is available. It shades recognized areas rather than drawing size-scaled bubbles. Choose it when the region itself is the unit of comparison, not when you need a separate marker for every store or city.
Frequently Asked Questions
Can Excel make a bubble map directly?
Yes, with 3D Maps in Excel for Microsoft 365 on Windows. The standard Filled Map chart does not support size-varying bubble markers, so use a Bubble layer in 3D Maps for that effect.
How do I make bubble size represent sales?
In the 3D Maps Layer pane, choose the Bubble visualization and assign the numeric sales field to Height. Confirm that the field contains numbers and that the values represent the totals you intend to compare.
Can I create a map bubble chart in Excel for Mac?
Excel for Mac does not include 3D Maps. You can use another mapping tool to create the bubble map and place an exported image in the workbook, or use an available standard chart type for a non-map comparison.
What is the difference between a bubble map and a Filled Map?
A bubble map places circles at locations and uses circle size to show a value. A Filled Map colors geographic regions according to a value. They answer related but different questions and are not interchangeable chart formats.
Why does Excel put a city in the wrong location?
Place names can be ambiguous or incomplete. Add a state, province, country, or other location field, make sure postal codes retain their leading zeroes, and review the result rather than assuming every match is correct.
Related
- How to Transpose in Excel: Turn Rows Into Columns Easily
- Transpose in Excel Without Pasting: 3 Practical Methods
- Insert and Delete Rows in Excel: Keyboard Shortcuts
Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.
More in Charts & pivot tables
- Excel Scatter Plot Axis Labels: Add and Format ThemTo add axis labels (axis titles) to an Excel scatter plot in Microsoft 365 for Windows, select the…
- Excel Trendline Formula in a Cell: Methods and ExamplesYes. To calculate a linear trendline estimate in an Excel cell, use FORECAST.LINEAR or calculate the slope and…
- Excel Mac Chart Creation: Make and Format ChartsTo create a chart in Excel for Mac, select your data, choose Insert > Recommended Charts, select a…
- Excel Pivot Table Date Sorting: Get Chronological OrderTo sort dates chronologically in an Excel PivotTable, right-click a date in the row or column labels and…
- Format Chart Area in Excel: A Practical GuideTo format a chart area in Excel for Microsoft 365 on Windows, select the chart, right-click its outer…
- 24-Hour Gantt Chart Excel: 24 Setup Ideas That WorkTo make a 24-hour Gantt chart in Excel, put 24 hourly time values across the columns, list tasks…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.