Easily create a matrix bubble chart in Excel
Kutools for Excel
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.
1. Click Kutools > Charts > Difference Comparison > Matrix Bubble Chart.
Tips: You also can select the data range in advance and then enable the feature.
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.
Notes:
Now the matrix bubble chart is created in current worksheet.
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.
2. In the opening Format Data Series pane, enter the new bubble size into the Scale bubble size to box to meet your need.
The following tools can greatly save your time and money, which one is right for you?
Office Tab: Using handy tabs in your Office, as the way of Chrome, Firefox and New Internet Explorer.
Kutools for Excel: More than 300 Advanced Functions for Excel 2021, 2019, 2016, 2013, 2010, 2007 and Office 365.
Kutools for Excel
The functionality described above is just one of 300 powerful functions of Kutools for Excel.
Designed for Excel(Office) 2021, 2019, 2016, 2013, 2010, 2007 and Office 365. Free download and use for 60 days.