Skip to main content

Easily create a matrix bubble chart in Excel

Author: Siluvia Last Modified: 2024-11-21

Kutools for Excel

Boosts Excel With 300+
Powerful Features

Matrix bubble chart is often used for displaying data with more data series in Excel. If you want to create a matrix bubble chart in Excel, here highly recommend the Matrix Bubble Chart utility of Kutools for Excel. With this feature, a matric bubble chart can be created with several clicks only.


Easily create a matrix bubble chart in Excel

Supposing you want to create a matrix bubble chart based on the data as the below screenshot shown, please do as follows to create a matrix bubble chart in Excel.

shot-matrix-bubble-chart-1

1. Click Kutools > Charts > Difference Comparison > Matrix Bubble Chart.
Tips: You also can select the data range in advance and then enable the feature.

shot-matrix-bubble-chart-2

2. In the popping up Matrix Bubble Chart dialog box, please configure as follows.

Note: If you have selected the data range in step 1, the data range will be displayed in the Data range box automatically.

2.1) In the Data range box, please select the range you want to create a matrix bubble chart based on (including the column and row headers);
2.2) By default, the Show data labels checkbox is ticked. If you don’t want to display the data labels in the chart, please untick this box;
2.3) Click the OK button to create the matrix bubble chart.

shot-matrix-bubble-chart-3

Notes:

1) By default, the bubbles are vary colors. If you want to display all bubbles in the same color, please check the Set color box and then specify a color from the drop-down list;
2) You can check the Switch rows/columns to switch the X-axis and Y-axis as you need.
3) Click the Example button to open the matrix bubble chart sample.

Now the matrix bubble chart is created in current worksheet.

shot-matrix-bubble-chart-4

Note: When creating matrix bubble chart in Excel 2007 and 2010, the x and y-axis values in the chart will not dynamically change with the cell values.

Tips:

Change the bubble size

Normally, the bubble size is scaled to 50%. If you want to change the bubble size, please do as follows.

1. Right click on any of the bubbles in the chart, and then select Format Data Labels from the context menu.

shot-matrix-bubble-chart-5

2. In the opening Format Data Series pane, enter the new bubble size into the Scale bubble size to box to meet your need.

shot-matrix-bubble-chart-6


Productivity Tools Recommended

Office Tab: Use handy tabs in Microsoft Office, just like Chrome, Firefox, and the new Edge browser. Easily switch between documents with tabs β€” no more cluttered windows. Know more...

Kutools for Outlook: Kutools for Outlook offers 100+ powerful features for Microsoft Outlook 2010–2024 (and later versions), as well as Microsoft 365, helping you simplify email management and boost productivity. Know more...


Kutools for Excel

Kutools for Excel offers 300+ advanced features to streamline your work in Excel 2010 – 2024 and Microsoft 365. The feature above is just one of many time-saving tools included.

🌍 Supports 40+ interface languages
βœ… Trusted by 500,000+ users and 80,000+ businesses worldwide
πŸš€ Compatible with all modern Excel versions
🎁 30-day full-featured trial β€” no registration, no limitations
Kutools for Excel RibbonKutools for Excel Ribbon