Create a matrix bubble chart in Excel

Normally, you may use a bubble chart to compare at least three sets of values and show the relationships within them. However, if there are at least three sets of values and each set of values has more series, how to compare all series values by bubble chart? Here we are going to show you a new chart - Matrix Bubble Chart. This chart can help to compare more series of at least three sets of values and show the relationships between them by placing the bubbles in a matrix permutation way.
Corresponding step-by-step guide:
www.extendoffi...

[@TheLabmate]

Thank you for kindly uploading this excellent video on matrix bubble chart in Excel. Else, it is really complex to do in R. Wish you could also add a sound track. Thank you for taking the time to share it. 👏👏👏

[@ExtendOffice99]

Hello friend, Glad it was helpful! Sorry that we won't add a soundtrack to this video in the near future. So we highly recommend you read our article for a step-by-step guide: www.extendoffice.com/excel/excel-charts/excel-matrix-bubble-chart.html. Apart from the method we introduced in the video, here is another quick method we want to share with you. The Matrix Bubble Chart utility of Kutools for Excel can help you quickly create a matrix bubble chart in Excel with several clicks only. For the details, read this article: www.extendoffice.com/product/kutools-for-excel/excel-matrix-bubble-chart.html. Sincerely, Mandy

[@user-qs9dp3sp2t]

It's very useful tnx❤️

[@ExtendOffice99]

Glad to hear that

[@amalben209]

great job thanks

[@ExtendOffice99]

You are welcome!

[@praveenuragonda5822]

Thank you sir

[@ExtendOffice99]

Welcome

[@jvnaveen8872]

Thanks

[@ExtendOffice99]

Hello friend, You are welcome. Glad it helps. Any questions, please feel free to contact us. Have a great day. Sincerely, Extendoffice.com

[@MohamedIsmail-gi4ki]

It wooow... Thanks a lot... KEEP up

[@ExtendOffice99]

Glad it is helpful. Have a nice day.

[@samkab677]

I want to add names as secondary horizontal axis.. any idea please?

[@Toobalify]

Excelente!

[@ExtendOffice99]

Glad it helps!

[@swarags4436]

Thank you for the nice video. I don’t know the reason but how much ever I am trying not able to get bubbles for Series4 and Series5. Please help me where I am going wrong?

[@ExtendOffice99]

Hello friend, Glad to help. I guess maybe you missed some steps in the video so you can't get bubbles for Series 4 and Series 5. It's possible because the steps to create a matrix bubble chart in Excel using the built-in feature of Excel are rather complicated. It involves over 20 steps. But please don't worry. The Matrix Bubble Chart utility of Kutools for Excel can help you quickly create a matrix bubble chart in Excel with several clicks. You can download Kutools for Excel for a 30-day free trial here： www.extendoffice.com/download/kutools-for-excel.html. You can read this article for more details: www.extendoffice.com/excel/excel-charts/excel-matrix-bubble-chart.html#KTE If you prefer the complicated method in the video and want clear instructions, please read this article: www.extendoffice.com/excel/excel-charts/excel-matrix-bubble-chart.html#a1. Sincerely, Mandy

[@swarags4436]

Thank you for quick response. I also noticed that excel have limitations for number of columns. This was the problem for me since I had 8 columns of data.

[@TheDemeaN]

In your X-axis table it should not be "Jan, Feb, Mar, Apr, May, Jun", but "2018, 2019, 2020, 2021, 2022"

[@ExtendOffice99]

Thank you for your suggestion. The method in whole in the video is no problem. When setting the value, it is also set as the X axis with "2018, 2019, 2020, 2021, 2022". The table is marked incorrectly, but not the setting of the data.

[@TheDemeaN]

@@ExtendOffice99 Exactly! Nonetheless, it is a great tutorial to overcome such a challenge that should be easier to implement in excel.

[@ExtendOffice99]

Hello friend, Sorry for the late reply. If you just use Excel's own functions to create a matrix bubble chart, the steps will be complicated and cumbersome. But the Matrix Bubble Chart feature of Kutools for Excel can help you quickly create a matrix bubble chart in Excel with just a few clicks. For more details, please read our article: www.extendoffice.com/product/kutools-for-excel/excel-matrix-bubble-chart.html.