In this tutorial, you will learn how to create a bubble chart with labels in Excel.
What is the purpose of a bubble chart? The main purpose of a bubble chart is to represent and highlight correlations between numerical variables. They are an excellent resource for determining the connections between variables and exploring connections between important business metrics like cost, value, and risk.
Once you are ready, we can get started by using real-life scenarios to help you understand how to create a bubble chart with labels in Excel.
Table of Contents
Create a Bubble Chart with Labels
Before we begin we will need a group of data to be used to create a bubble chart with labels in Excel.
Step 1
Make sure your group of data is displayed in a clean and tidy manner in the first sheet.
Step 2
To create a bubble chart, we first need to select ‘Insert’, then select ‘Bubble’.
Step 3
Your bubble chart will look like this.
Step 4
To add in the labels, we will select ‘Chart Design’, then select ‘Data labels’ and select ‘More Data Label Options’.
Step 5
In the Format Data Labels, we will select the labels from the cells and centre the labels.
Step 6
Once you are done, your bubble chart will look like this.
