How can we help?

Close
icon

Give us a call

Our team of experts are on hand and ready to help.

0161 883 2655
icon

Live chat

Ready to chat data? That's what we're here for

icon

Submit an enquiry

Fill out your details and one of the team will be in touch

Get in touch

Excel’s bubble chart function allows users to visualise the relationship between multiple data values in a simple way.

As with scatter graphs, bubble charts are used to plot a set of values on both horizontal (x) and vertical (y) axes; however, there is also an extra dimension (z) which is represented in the size of each bubble. That makes this type of chart an ideal option for those looking to present three data series, each containing a separate set of values, at the same time.

Due to the fact that bubble charts are designed to show more complex relationships between data values compared with a simple scatter graph, they can often prove to be a challenge for those who do not have a solid knowledge of Excel functions.

How Excel bubble charts can optimise processes

There are countless scenarios in which businesses opt for bubble charts to show the relationship between multiple data values clearly and accurately. One of the most common is when presenting financial data. In a standard financial modelling project, for instance, you may need to plot the number of products (x), a sales estimate (y) and the projected return on investment (size of bubble).

Bubble charts tend to display a higher level of information at once, so they aren’t always as immediately easy to understand compared to a two-dimensional graph. The most effective bubble charts are accompanied by a clear explanation of what is being shown, particularly when delivering insights as part of a company report.

Top tip: Save yourself some time by not using bubble charts if you only need to display two data series; a trusty scatter graph will do just fine.

How to create a bubble chart in Excel

We’ve put together this simple step-by-step walkthrough for Excel users who are looking to create a basic bubble chart from scratch.

1. Arrange your data

First, organise your selected data values in rows or columns within an Excel spreadsheet. The x values should be in the first row or column, the y values in the second and z values (bubble size) in the third.

2. Select data and navigate to “Insert Bubble Chart”

Highlight the data you want to include in the bubble chart (without any column headings) then insert a bubble chart from the Excel menu – Insert > Charts > Scatter Graphs > Bubble Chart.

3. Choose your preferred design

Click into the chart area of the chart to display Chart Tools. From there, navigate to the Design tab and select the style you would like to use.

4. Format the chart accordingly

Excel offers a range of customisable options that afford users control over the size, shape height and shape width of data points within the bubble chart, as well as gridlines and additional data labels. Once you are happy with your selections and axes titles, click Enter to insert the bubble chart.

5. Apply further formatting effects as required

From the Format tab in the Excel menu, click an individual chart element or select the current selection group to edit different shapes, styles and effects. It is also possible to include specific theme colours that are different from your spreadsheet’s default theme.

Looking for professional Excel support?

The task of using bubble charts to optimise business process and present clear data insights isn’t always a walk in the park. If you require additional support with more complex graphs and data visualisation techniques then it’s worth getting in touch with an experienced Excel professional rather than going it alone.

Are bubble charts a part of an Excel project you have? Get in touch with our team of expert Excel consultants today on 0161 883 2655.

Graphic

Our blog

Get up to speed on what’s happening in the world of Data…