How to create a bubble chart with multiple series in Excel?

Dive into the dynamic world of Excel charts with our new KZbin video from our Data to Decisions series!
In this video, you’ll learn to create a bubble chart with multiple series and labels, allowing for an intricate display of data points across various dimensions.
This tutorial walks you through the intricacies of visualizing the relationship between revenue, net margin, and employee count by sector.
We’ll also look at the analysis that can be derived from the chart which can help in informed decision making.
Get ready to bubble up your data storytelling skills with simple yet effective charts created instantly.
Check our videos on motion bubble charts here:
How to create a motion bubble chart in Excel:
• Create Motion Bubble C...
Types of analysis that can be performed with a motion bubble chart:
• 4 types of analysis wi... .
Check our detailed blog posts on our Data to Decisions page:
indzara.com/cr...
For tutorials that address common Excel problems, visit indzara.com/da...
Try our free motion bubble chart template in Excel:
indzara.com/fr...
#datavisualization #chartsinexcel #DatatoDecisions #visualization #charts

[@adityashettigar5146]

Amazing… was really helpful

[@indzara]

Thank you for sharing your valuable feedback. We are glad that our video was helpful. Best wishes.

[@srishail05]

Thank you. very helpful

[@indzara]

You are welcome. We are glad our video was helpful. Best wishes.

[@astronomicaltalk5708]

I ended up with two types of leader line, a thin line which is what I wanted but also a tapered line, how do I remove the tapered pointer please? Thank you.

[@indzara]

Please share your copy of the file with the chart and sample data having the highlighted issue at the below and we will be glad to assist you: support.indzara.com/support/tickets/new Best wishes.

[@JayeshVadnere8888]

Suppose, data is of more than 10000 rows and having 50 different categories like tech, bank, etc. How to plot bubble chart? It there any simple method other than this way? Thank you, this method is also helpful.

[@indzara]

You are welcome. Thank you for sharing your valuable feedback. Currently, different series of data cannot be added to the chart dynamically. Hence it has to be manually done for 50 different categories. However the same could be possible using Macros but currently we do not have a ready-made solution for the same. Best wishes.