Select the 'Add data' option from the bottom of this menu. Right-click anywhere on the bubble chart, which enables a pop-up menu to appear. This allows a basic bubble chart to appear on your screen. Then, select the bubble chart option from the drop-down menu. Insert the bubble chartįrom the toolbar, select the 'Scatter' option, which sometimes appears as a small graphic of a scatter chart. Related: A Guide to Bar Graphs and 6 Steps on How To Draw a Bar Graph 2. To open a new spreadsheet, select the 'File' tab, then select 'New.' Once you open the sheet, click the 'Insert' button, which prompts a toolbar of numerous graphics and charts to appear at the top of your screen. To begin, open the Excel sheet where you intend to include the bubble chart. Here are the steps you can take to create a bubble chart using the bubble function: 1. Typically, using the bubble function in Excel to create a bubble chart is easy for users to complete, and it provides you with options to customize each bubble in your chart. How to create a bubble chart in Excel using the bubble function You may dedicate a bubble on the chart to each type of information. For example, if you are reviewing each employee's attendance records, sales revenue and customer growth. You may also use a bubble chart in Excel when you are handling numerous types of information that relates to one topic. This may help sales professionals compare each strategy visually, rather than reviewing sales numbers and statistics. In this case, you might represent each strategy using a bubble, and the size of the bubble determines the amount of profit that your workplace received from using that strategy previously. For example, you might use a bubble chart to compare several sales strategies to see which one is the most cost-effective. This chart allows you to show their relationships by changing the size of the bubbles and each bubble's location on the chart. You may use a bubble chart when comparing numerous variables to one another. Related: What Are Project Charts? (13 Examples and When To Use Them) When to use a bubble chart in Excel

On the chart, you can arrange each bubble's size, location and color to reveal further information about the circle's relationship to one another. Typically, bubble charts allow you to share data about three or more variables. Related: A Guide to Bubble Charts What is a bubble chart in Excel?Ī bubble chart is a type of data visualization graph that uses circles, also known as bubbles, to represent the information that you collected. In this article, we explain what a bubble chart is, discuss why you might use one and provide the steps you can take to create your own. Learning how to create a bubble chart in Excel may help you present complex information visually.

You may use this chart to organize important data, which may allow you to make more informed decisions. A bubble chart allows you to use circles to present different types of information on a graph.

Excel bubble diagram