Create a matrix bubble chart in Excel
ฝัง
- เผยแพร่เมื่อ 14 ต.ค. 2024
- 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...
![[DRIP] ‘Love, Maybe’ PREVIEW](http://i.ytimg.com/vi/U7hwHp95m1k/mqdefault.jpg)
Awesome!!! ❤❤
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. 👏👏👏
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
I want to add names as secondary horizontal axis.. any idea please?
It's very useful tnx❤️
Glad to hear that
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?
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
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.
great job thanks
You are welcome!
Thank you sir
Welcome
Excelente!
Glad it helps!
Thanks
Hello friend,
You are welcome. Glad it helps. Any questions, please feel free to contact us. Have a great day.
Sincerely,
Extendoffice.com
It wooow... Thanks a lot... KEEP up
Glad it is helpful. Have a nice day.
In your X-axis table it should not be "Jan, Feb, Mar, Apr, May, Jun", but "2018, 2019, 2020, 2021, 2022"
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.
@@ExtendOffice99 Exactly! Nonetheless, it is a great tutorial to overcome such a challenge that should be easier to implement in excel.
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.