PINGDOM_CANARY_STRING
how to make a bubble chart in Excel

How to Make a Bubble Chart in Excel

Reading time: about 3 min

Posted by: Shannon Williams

At Lucid, we believe in the power of data visualization. Your data can tell a story and persuade others if you present it in the right way. But what happens when you have multiple data sets? How can you elegantly display all the metrics you need without overwhelming your audience?

The answer: bubble charts. We’ll explain how bubble charts can tastefully organize several dimensions of data and then show you how to make a bubble chart in Excel, right alongside your data, using Lucidchart.

Already know that you need a bubble chart? Skip down to the tutorial.

What is a bubble chart?

Just in case you’re not sure whether a bubble chart best fits your project, let’s quickly define this type of visualization.

Bubble charts display data in three (or even four) dimensions. Like a traditional scatter plot, you can show different metrics on the x-axis and y-axis of the chart. Then you can visualize a third dimension of data through the scale of the bubbles. The larger the bubble, the larger its value. If you need to visualize a fourth data set, you can use different colors to group the bubbles into categories.

In other words, if you’ve had to use multiple bar graphs or scatter plots to share results, you can create a bubble chart to consolidate all of that data.

bubble chart template
Bubble Chart Template (Click on image to modify online)

If your data includes location, you can use the same elements shown above to create a bubble map, also called a cartogram. You’ll essentially lay the standard bubble chart over a geographic map, the x-axis and y-axis becoming the latitude and longitude.

bubble map template
Bubble Map/Cartogram Template (Click on image to modify online)

Although Excel will generate a bubble chart from your data, the process is very complex and doesn’t allow you to customize the chart according to your company standards. With Lucidchart’s intuitive interface and Microsoft Office integrations, you can quickly put together a clear, on-brand bubble chart and insert it directly into Excel.

How to create a bubble chart in Lucidchart

First, let’s turn your data into an engaging visual in Lucidchart. If you don’t have a Lucidchart account yet, sign up for your free account!

  1. Open our bubble chart template.
  2. Adjust the x-axis, y-axis, and circles according to the data you’d like to display.
  3. Use the Properties bar at the top of the editor to adjust fonts and colors according to your brand.

If you would rather build your bubble chart from scratch, we have a few tips to help you out:

  • Our opaque Venn diagram shapes work perfectly for bubble charts. To open this library, click “+ Shapes” on the left side of the editor, check “Venn Diagrams,” and select “Save.” You’ll see your new shape library below the standard shapes.
  • To add lines, click “L” or drag an arrow from the shape library. From the Properties bar at the top, you can change the endpoints to “None” for a plain line.

How to import your bubble chart into Excel

Now you can insert your bubble chart into any Excel document with the Lucidchart add-on. Follow these simple steps to install and use the add-on.

  1. In Excel, select Insert > My Add-ins.
  2. Search for Lucidchart in the marketplace.
  3. Click “Add” to install. The add-on will appear as a sidebar.
  4. Once you’ve connected your Lucidchart account, select your bubble chart and click “Insert.”

Watch this short video for a complete walkthrough of the process.

Beyond bubble charts, Lucidchart can help you visualize and clarify all types of information and processes.

Get your free account today and see what ideas you can put together on our canvas.

About the author

Shannon Williams profile picture

Shannon Williams graduated from BYU in English and then turned to the world of marketing. She works as a content marketing specialist at Lucid Software. Instead of writing her novel (like she should be), Shannon spends her free time running, reading, obsessing about Oscar season, and watching Gilmore Girls on loop.

Start diagramming with Lucidchart today—try it for free!

Sign up free

Popular now

what does HR do

What Does HR Actually Do? 11 Key Responsibilities

About Lucidchart

Lucidchart is the intelligent diagramming application that empowers teams to clarify complexity, align their insights, and build the future—faster. With this intuitive, cloud-based solution, everyone can work visually and collaborate in real time while building flowcharts, mockups, UML diagrams, and more.

The most popular online Visio alternative, Lucidchart is utilized in over 180 countries by millions of users, from sales managers mapping out target organizations to IT directors visualizing their network infrastructure.

Related posts:

How to Make a Decision Tree in Excel

how to make a decision tree in excel
English
PrivacyLegal
© 2021 Lucid Software Inc.